/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80036
 Source Host           : localhost:3306
 Source Schema         : rpsm

 Target Server Type    : MySQL
 Target Server Version : 80036
 File Encoding         : 65001

 Date: 17/03/2025 18:56:34
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for amount
-- ----------------------------
DROP TABLE IF EXISTS `amount`;
CREATE TABLE `amount`  (
  `amount_id` int NOT NULL AUTO_INCREMENT,
  `amount_roomid` int NOT NULL,
  `amount_type` smallint NOT NULL COMMENT '1、水费；2、电费；3、物业费',
  `amount_date` date NOT NULL COMMENT '统计时间',
  `amount` int NOT NULL COMMENT '计数总量（水费和电费，物业费作为固定费用，以建筑面积计算）',
  `isPaied` int NOT NULL COMMENT '1:已支付；2、未支付',
  PRIMARY KEY (`amount_id`) USING BTREE,
  INDEX `amount_roomid`(`amount_roomid`) USING BTREE,
  CONSTRAINT `amount_ibfk_1` FOREIGN KEY (`amount_roomid`) REFERENCES `room` (`room_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '水电费每月使用数量' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of amount
-- ----------------------------
INSERT INTO `amount` VALUES (1, 25, 1, '2023-12-17', -28000, 2);
INSERT INTO `amount` VALUES (2, 26, 2, '2022-01-01', -3800, 2);
INSERT INTO `amount` VALUES (3, 27, 3, '2022-10-01', -380000, 2);
INSERT INTO `amount` VALUES (4, 25, 2, '2023-12-17', 20000, 1);
INSERT INTO `amount` VALUES (5, 28, 1, '2022-01-01', 4000, 1);

-- ----------------------------
-- Table structure for attention
-- ----------------------------
DROP TABLE IF EXISTS `attention`;
CREATE TABLE `attention`  (
  `attention_id` int NOT NULL AUTO_INCREMENT,
  `from_id` int NOT NULL COMMENT '发起关注的用户id',
  `to_id` int NOT NULL COMMENT '被关注的用户id',
  `attend_date` date NOT NULL COMMENT '关注时间',
  `isAttend` int NULL DEFAULT 1 COMMENT '是否已关注 1已关注 0未关注，主要用于关注列表反复修改',
  PRIMARY KEY (`attention_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of attention
-- ----------------------------
INSERT INTO `attention` VALUES (3, 3, 4, '2023-12-13', 1);
INSERT INTO `attention` VALUES (4, 4, 3, '2023-12-11', 1);
INSERT INTO `attention` VALUES (5, 6, 3, '2023-12-15', 1);
INSERT INTO `attention` VALUES (6, 13, 3, '2023-12-17', 0);
INSERT INTO `attention` VALUES (7, 3, 13, '2023-12-17', 1);
INSERT INTO `attention` VALUES (8, 3, 6, '2024-05-10', 1);

-- ----------------------------
-- Table structure for building
-- ----------------------------
DROP TABLE IF EXISTS `building`;
CREATE TABLE `building`  (
  `building_id` int NOT NULL AUTO_INCREMENT,
  `building_code` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '小区名+楼栋编号的方式',
  `building_name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '楼栋名称',
  `building_status` smallint NOT NULL COMMENT '1、使用；2、未使用',
  `building_floors` smallint NOT NULL COMMENT '楼层数',
  `completed_date` date NOT NULL COMMENT '建成时间',
  `design_life` smallint NOT NULL COMMENT '设计年限',
  `ownership` smallint NOT NULL COMMENT '产权年限',
  PRIMARY KEY (`building_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of building
-- ----------------------------
INSERT INTO `building` VALUES (3, 'tcyp01', '汤臣一品01号楼', 1, 28, '2010-01-01', 100, 70);
INSERT INTO `building` VALUES (4, 'tcyp02', '汤臣一品02号楼', 1, 28, '2010-01-01', 100, 70);
INSERT INTO `building` VALUES (5, 'tcyp03', '汤臣一品03号楼', 1, 28, '2010-01-01', 100, 70);
INSERT INTO `building` VALUES (6, 'tcyp04', '汤臣一品04号楼', 1, 28, '2010-01-01', 100, 70);
INSERT INTO `building` VALUES (7, 'tcyp05', '汤臣一品05号楼', 1, 28, '2010-01-01', 100, 70);
INSERT INTO `building` VALUES (8, 'tcyp06', '汤臣一品06号楼', 1, 28, '2010-01-01', 100, 70);
INSERT INTO `building` VALUES (9, 'yhtx01', '御湖天下01号楼', 2, 38, '2019-01-22', 100, 70);
INSERT INTO `building` VALUES (10, 'yhtx02', '御湖天下02号楼', 2, 38, '2019-01-22', 100, 70);
INSERT INTO `building` VALUES (11, 'yhtx03', '御湖天下03号楼', 2, 38, '2019-01-22', 100, 70);
INSERT INTO `building` VALUES (12, 'yhtx04', '御湖天下04号楼', 2, 38, '2019-01-22', 100, 70);
INSERT INTO `building` VALUES (13, 'yhtx05', '御湖天下05号楼', 2, 38, '2019-01-22', 100, 70);
INSERT INTO `building` VALUES (14, 'yhtx06', '御湖天下06号楼', 2, 38, '2019-01-22', 100, 70);
INSERT INTO `building` VALUES (15, 'yhtx07', '御湖天下07号楼', 2, 38, '2019-01-22', 100, 70);
INSERT INTO `building` VALUES (16, 'yjw01', '御景湾01号楼', 2, 20, '2017-01-01', 50, 30);
INSERT INTO `building` VALUES (17, 'yjw02', '御景湾02号楼', 2, 20, '2017-01-01', 50, 30);
INSERT INTO `building` VALUES (18, 'yjw03', '御景湾03号楼', 2, 20, '2017-01-01', 50, 30);
INSERT INTO `building` VALUES (19, 'yjw04', '御景湾04号楼', 2, 20, '2017-01-01', 50, 30);
INSERT INTO `building` VALUES (20, 'yjw05', '御景湾05号楼', 2, 20, '2017-01-01', 50, 30);

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment`  (
  `comment_id` int NOT NULL AUTO_INCREMENT,
  `comment_content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `comment_publish_time` datetime(0) NULL DEFAULT NULL,
  `comment_userid` int NOT NULL,
  `comment_parent_message_id` int NOT NULL COMMENT '评论上一级id(消息）',
  `comment_parent_comment_id` int NULL DEFAULT 0 COMMENT '评论上一级id(评论）',
  `comment_like` int NULL DEFAULT 0 COMMENT '评论点赞',
  `comment_unlike` int NULL DEFAULT 0,
  PRIMARY KEY (`comment_id`) USING BTREE,
  INDEX `comment_parent_message_id`(`comment_parent_message_id`) USING BTREE,
  INDEX `comment_parent_comment_id`(`comment_parent_comment_id`) USING BTREE,
  INDEX `comment_publish_time`(`comment_publish_time`) USING BTREE,
  INDEX `comment_userid`(`comment_userid`) USING BTREE,
  CONSTRAINT `comment_ibfk_1` FOREIGN KEY (`comment_parent_message_id`) REFERENCES `message` (`message_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `comment_ibfk_2` FOREIGN KEY (`comment_parent_comment_id`) REFERENCES `comment` (`comment_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `comment_ibfk_3` FOREIGN KEY (`comment_userid`) REFERENCES `user` (`userid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of comment
-- ----------------------------
INSERT INTO `comment` VALUES (2, '测试01', '2023-03-01 00:30:00', 3, 3, NULL, 3, 0);
INSERT INTO `comment` VALUES (4, '好好好好', '2023-12-11 16:09:14', 4, 3, NULL, 0, 0);
INSERT INTO `comment` VALUES (5, '太好了', '2023-12-11 16:17:17', 4, 3, NULL, 0, 0);
INSERT INTO `comment` VALUES (6, '《javascript从入门到放弃》，标题太有意思了，哈哈哈', '2023-12-11 16:23:05', 4, 4, NULL, 0, 0);
INSERT INTO `comment` VALUES (9, '测试发送父评论和发送子评论合并为一个方法下发送父评论', '2023-12-12 09:10:24', 3, 3, NULL, 4, 0);
INSERT INTO `comment` VALUES (10, '测试发送父评论和发送子评论合并为一个方法下发送子评论', '2023-12-12 09:10:43', 3, 3, 9, 1, 0);
INSERT INTO `comment` VALUES (15, '111', '2023-12-15 02:55:49', 6, 4, NULL, 0, 0);
INSERT INTO `comment` VALUES (16, '1111', '2023-12-15 02:55:58', 6, 4, 15, 0, 0);
INSERT INTO `comment` VALUES (17, '666', '2023-12-17 13:03:19', 13, 4, NULL, 0, 0);
INSERT INTO `comment` VALUES (18, '1', '2023-12-17 13:03:30', 13, 4, 6, 0, 0);

-- ----------------------------
-- Table structure for floor
-- ----------------------------
DROP TABLE IF EXISTS `floor`;
CREATE TABLE `floor`  (
  `floor_id` int NOT NULL AUTO_INCREMENT,
  `belong_building` int NOT NULL COMMENT '所属楼栋',
  `floor_number` smallint NOT NULL COMMENT '层号',
  `room_number` smallint NOT NULL COMMENT '楼层房间数',
  PRIMARY KEY (`floor_id`) USING BTREE,
  INDEX `belong_building`(`belong_building`) USING BTREE,
  CONSTRAINT `floor_ibfk_1` FOREIGN KEY (`belong_building`) REFERENCES `building` (`building_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 484 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of floor
-- ----------------------------
INSERT INTO `floor` VALUES (9, 3, 1, 2);
INSERT INTO `floor` VALUES (10, 3, 2, 2);
INSERT INTO `floor` VALUES (11, 3, 3, 2);
INSERT INTO `floor` VALUES (12, 3, 4, 2);
INSERT INTO `floor` VALUES (13, 3, 5, 2);
INSERT INTO `floor` VALUES (14, 3, 6, 2);
INSERT INTO `floor` VALUES (15, 3, 7, 2);
INSERT INTO `floor` VALUES (16, 3, 8, 2);
INSERT INTO `floor` VALUES (17, 3, 9, 2);
INSERT INTO `floor` VALUES (18, 3, 10, 2);
INSERT INTO `floor` VALUES (19, 3, 11, 2);
INSERT INTO `floor` VALUES (20, 3, 12, 2);
INSERT INTO `floor` VALUES (21, 3, 13, 2);
INSERT INTO `floor` VALUES (22, 3, 14, 2);
INSERT INTO `floor` VALUES (23, 3, 15, 2);
INSERT INTO `floor` VALUES (24, 3, 16, 2);
INSERT INTO `floor` VALUES (25, 3, 17, 2);
INSERT INTO `floor` VALUES (26, 3, 18, 2);
INSERT INTO `floor` VALUES (27, 3, 19, 2);
INSERT INTO `floor` VALUES (28, 3, 20, 2);
INSERT INTO `floor` VALUES (29, 3, 21, 2);
INSERT INTO `floor` VALUES (30, 3, 22, 2);
INSERT INTO `floor` VALUES (31, 3, 23, 2);
INSERT INTO `floor` VALUES (32, 3, 24, 2);
INSERT INTO `floor` VALUES (33, 3, 25, 2);
INSERT INTO `floor` VALUES (34, 3, 26, 2);
INSERT INTO `floor` VALUES (35, 3, 27, 2);
INSERT INTO `floor` VALUES (36, 3, 28, 2);
INSERT INTO `floor` VALUES (37, 4, 1, 2);
INSERT INTO `floor` VALUES (38, 4, 2, 2);
INSERT INTO `floor` VALUES (39, 4, 3, 2);
INSERT INTO `floor` VALUES (40, 4, 4, 2);
INSERT INTO `floor` VALUES (41, 4, 5, 2);
INSERT INTO `floor` VALUES (42, 4, 6, 2);
INSERT INTO `floor` VALUES (43, 4, 7, 2);
INSERT INTO `floor` VALUES (44, 4, 8, 2);
INSERT INTO `floor` VALUES (45, 4, 9, 2);
INSERT INTO `floor` VALUES (46, 4, 10, 2);
INSERT INTO `floor` VALUES (47, 4, 11, 2);
INSERT INTO `floor` VALUES (48, 4, 12, 2);
INSERT INTO `floor` VALUES (49, 4, 13, 2);
INSERT INTO `floor` VALUES (50, 4, 14, 2);
INSERT INTO `floor` VALUES (51, 4, 15, 2);
INSERT INTO `floor` VALUES (52, 4, 16, 2);
INSERT INTO `floor` VALUES (53, 4, 17, 2);
INSERT INTO `floor` VALUES (54, 4, 18, 2);
INSERT INTO `floor` VALUES (55, 4, 19, 2);
INSERT INTO `floor` VALUES (56, 4, 20, 2);
INSERT INTO `floor` VALUES (57, 4, 21, 2);
INSERT INTO `floor` VALUES (58, 4, 22, 2);
INSERT INTO `floor` VALUES (59, 4, 23, 2);
INSERT INTO `floor` VALUES (60, 4, 24, 2);
INSERT INTO `floor` VALUES (61, 4, 25, 2);
INSERT INTO `floor` VALUES (62, 4, 26, 2);
INSERT INTO `floor` VALUES (63, 4, 27, 2);
INSERT INTO `floor` VALUES (64, 4, 28, 2);
INSERT INTO `floor` VALUES (65, 5, 1, 2);
INSERT INTO `floor` VALUES (66, 5, 2, 2);
INSERT INTO `floor` VALUES (67, 5, 3, 2);
INSERT INTO `floor` VALUES (68, 5, 4, 2);
INSERT INTO `floor` VALUES (69, 5, 5, 2);
INSERT INTO `floor` VALUES (70, 5, 6, 2);
INSERT INTO `floor` VALUES (71, 5, 7, 2);
INSERT INTO `floor` VALUES (72, 5, 8, 2);
INSERT INTO `floor` VALUES (73, 5, 9, 2);
INSERT INTO `floor` VALUES (74, 5, 10, 2);
INSERT INTO `floor` VALUES (75, 5, 11, 2);
INSERT INTO `floor` VALUES (76, 5, 12, 2);
INSERT INTO `floor` VALUES (77, 5, 13, 2);
INSERT INTO `floor` VALUES (78, 5, 14, 2);
INSERT INTO `floor` VALUES (79, 5, 15, 2);
INSERT INTO `floor` VALUES (80, 5, 16, 2);
INSERT INTO `floor` VALUES (81, 5, 17, 2);
INSERT INTO `floor` VALUES (82, 5, 18, 2);
INSERT INTO `floor` VALUES (83, 5, 19, 2);
INSERT INTO `floor` VALUES (84, 5, 20, 2);
INSERT INTO `floor` VALUES (85, 5, 21, 2);
INSERT INTO `floor` VALUES (86, 5, 22, 2);
INSERT INTO `floor` VALUES (87, 5, 23, 2);
INSERT INTO `floor` VALUES (88, 5, 24, 2);
INSERT INTO `floor` VALUES (89, 5, 25, 2);
INSERT INTO `floor` VALUES (90, 5, 26, 2);
INSERT INTO `floor` VALUES (91, 5, 27, 2);
INSERT INTO `floor` VALUES (92, 5, 28, 2);
INSERT INTO `floor` VALUES (93, 6, 1, 2);
INSERT INTO `floor` VALUES (94, 6, 2, 2);
INSERT INTO `floor` VALUES (95, 6, 3, 2);
INSERT INTO `floor` VALUES (96, 6, 4, 2);
INSERT INTO `floor` VALUES (97, 6, 5, 2);
INSERT INTO `floor` VALUES (98, 6, 6, 2);
INSERT INTO `floor` VALUES (99, 6, 7, 2);
INSERT INTO `floor` VALUES (100, 6, 8, 2);
INSERT INTO `floor` VALUES (101, 6, 9, 2);
INSERT INTO `floor` VALUES (102, 6, 10, 2);
INSERT INTO `floor` VALUES (103, 6, 11, 2);
INSERT INTO `floor` VALUES (104, 6, 12, 2);
INSERT INTO `floor` VALUES (105, 6, 13, 2);
INSERT INTO `floor` VALUES (106, 6, 14, 2);
INSERT INTO `floor` VALUES (107, 6, 15, 2);
INSERT INTO `floor` VALUES (108, 6, 16, 2);
INSERT INTO `floor` VALUES (109, 6, 17, 2);
INSERT INTO `floor` VALUES (110, 6, 18, 2);
INSERT INTO `floor` VALUES (111, 6, 19, 2);
INSERT INTO `floor` VALUES (112, 6, 20, 2);
INSERT INTO `floor` VALUES (113, 6, 21, 2);
INSERT INTO `floor` VALUES (114, 6, 22, 2);
INSERT INTO `floor` VALUES (115, 6, 23, 2);
INSERT INTO `floor` VALUES (116, 6, 24, 2);
INSERT INTO `floor` VALUES (117, 6, 25, 2);
INSERT INTO `floor` VALUES (118, 6, 26, 2);
INSERT INTO `floor` VALUES (119, 6, 27, 2);
INSERT INTO `floor` VALUES (120, 6, 28, 2);
INSERT INTO `floor` VALUES (121, 7, 1, 2);
INSERT INTO `floor` VALUES (122, 7, 2, 2);
INSERT INTO `floor` VALUES (123, 7, 3, 2);
INSERT INTO `floor` VALUES (124, 7, 4, 2);
INSERT INTO `floor` VALUES (125, 7, 5, 2);
INSERT INTO `floor` VALUES (126, 7, 6, 2);
INSERT INTO `floor` VALUES (127, 7, 7, 2);
INSERT INTO `floor` VALUES (128, 7, 8, 2);
INSERT INTO `floor` VALUES (129, 7, 9, 2);
INSERT INTO `floor` VALUES (130, 7, 10, 2);
INSERT INTO `floor` VALUES (131, 7, 11, 2);
INSERT INTO `floor` VALUES (132, 7, 12, 2);
INSERT INTO `floor` VALUES (133, 7, 13, 2);
INSERT INTO `floor` VALUES (134, 7, 14, 2);
INSERT INTO `floor` VALUES (135, 7, 15, 2);
INSERT INTO `floor` VALUES (136, 7, 16, 2);
INSERT INTO `floor` VALUES (137, 7, 17, 2);
INSERT INTO `floor` VALUES (138, 7, 18, 2);
INSERT INTO `floor` VALUES (139, 7, 19, 2);
INSERT INTO `floor` VALUES (140, 7, 20, 2);
INSERT INTO `floor` VALUES (141, 7, 21, 2);
INSERT INTO `floor` VALUES (142, 7, 22, 2);
INSERT INTO `floor` VALUES (143, 7, 23, 2);
INSERT INTO `floor` VALUES (144, 7, 24, 2);
INSERT INTO `floor` VALUES (145, 7, 25, 2);
INSERT INTO `floor` VALUES (146, 7, 26, 2);
INSERT INTO `floor` VALUES (147, 7, 27, 2);
INSERT INTO `floor` VALUES (148, 7, 28, 2);
INSERT INTO `floor` VALUES (149, 8, 1, 2);
INSERT INTO `floor` VALUES (150, 8, 2, 2);
INSERT INTO `floor` VALUES (151, 8, 3, 2);
INSERT INTO `floor` VALUES (152, 8, 4, 2);
INSERT INTO `floor` VALUES (153, 8, 5, 2);
INSERT INTO `floor` VALUES (154, 8, 6, 2);
INSERT INTO `floor` VALUES (155, 8, 7, 2);
INSERT INTO `floor` VALUES (156, 8, 8, 2);
INSERT INTO `floor` VALUES (157, 8, 9, 2);
INSERT INTO `floor` VALUES (158, 8, 10, 2);
INSERT INTO `floor` VALUES (159, 8, 11, 2);
INSERT INTO `floor` VALUES (160, 8, 12, 2);
INSERT INTO `floor` VALUES (161, 8, 13, 2);
INSERT INTO `floor` VALUES (162, 8, 14, 2);
INSERT INTO `floor` VALUES (163, 8, 15, 2);
INSERT INTO `floor` VALUES (164, 8, 16, 2);
INSERT INTO `floor` VALUES (165, 8, 17, 2);
INSERT INTO `floor` VALUES (166, 8, 18, 2);
INSERT INTO `floor` VALUES (167, 8, 19, 2);
INSERT INTO `floor` VALUES (168, 8, 20, 2);
INSERT INTO `floor` VALUES (169, 8, 21, 2);
INSERT INTO `floor` VALUES (170, 8, 22, 2);
INSERT INTO `floor` VALUES (171, 8, 23, 2);
INSERT INTO `floor` VALUES (172, 8, 24, 2);
INSERT INTO `floor` VALUES (173, 8, 25, 2);
INSERT INTO `floor` VALUES (174, 8, 26, 2);
INSERT INTO `floor` VALUES (175, 8, 27, 2);
INSERT INTO `floor` VALUES (176, 8, 28, 2);
INSERT INTO `floor` VALUES (177, 10, 1, 2);
INSERT INTO `floor` VALUES (178, 10, 2, 2);
INSERT INTO `floor` VALUES (179, 10, 3, 2);
INSERT INTO `floor` VALUES (180, 10, 4, 2);
INSERT INTO `floor` VALUES (181, 10, 5, 2);
INSERT INTO `floor` VALUES (182, 10, 6, 2);
INSERT INTO `floor` VALUES (183, 10, 7, 2);
INSERT INTO `floor` VALUES (184, 10, 8, 2);
INSERT INTO `floor` VALUES (185, 10, 9, 2);
INSERT INTO `floor` VALUES (186, 10, 10, 2);
INSERT INTO `floor` VALUES (187, 10, 11, 2);
INSERT INTO `floor` VALUES (188, 10, 12, 2);
INSERT INTO `floor` VALUES (189, 10, 13, 2);
INSERT INTO `floor` VALUES (190, 10, 14, 2);
INSERT INTO `floor` VALUES (191, 10, 15, 2);
INSERT INTO `floor` VALUES (192, 10, 16, 2);
INSERT INTO `floor` VALUES (193, 10, 17, 2);
INSERT INTO `floor` VALUES (194, 10, 18, 2);
INSERT INTO `floor` VALUES (195, 10, 19, 2);
INSERT INTO `floor` VALUES (196, 10, 20, 2);
INSERT INTO `floor` VALUES (197, 10, 21, 2);
INSERT INTO `floor` VALUES (198, 10, 22, 2);
INSERT INTO `floor` VALUES (199, 10, 23, 2);
INSERT INTO `floor` VALUES (200, 10, 24, 2);
INSERT INTO `floor` VALUES (201, 10, 25, 2);
INSERT INTO `floor` VALUES (202, 10, 26, 2);
INSERT INTO `floor` VALUES (203, 10, 27, 2);
INSERT INTO `floor` VALUES (204, 10, 28, 2);
INSERT INTO `floor` VALUES (205, 10, 29, 2);
INSERT INTO `floor` VALUES (206, 10, 30, 2);
INSERT INTO `floor` VALUES (207, 10, 31, 2);
INSERT INTO `floor` VALUES (208, 10, 32, 2);
INSERT INTO `floor` VALUES (209, 10, 33, 2);
INSERT INTO `floor` VALUES (210, 10, 34, 2);
INSERT INTO `floor` VALUES (211, 10, 35, 2);
INSERT INTO `floor` VALUES (212, 10, 36, 2);
INSERT INTO `floor` VALUES (213, 10, 37, 2);
INSERT INTO `floor` VALUES (214, 10, 38, 2);
INSERT INTO `floor` VALUES (215, 11, 1, 2);
INSERT INTO `floor` VALUES (216, 11, 2, 2);
INSERT INTO `floor` VALUES (217, 11, 3, 2);
INSERT INTO `floor` VALUES (218, 11, 4, 2);
INSERT INTO `floor` VALUES (219, 11, 5, 2);
INSERT INTO `floor` VALUES (220, 11, 6, 2);
INSERT INTO `floor` VALUES (221, 11, 7, 2);
INSERT INTO `floor` VALUES (222, 11, 8, 2);
INSERT INTO `floor` VALUES (223, 11, 9, 2);
INSERT INTO `floor` VALUES (224, 11, 10, 2);
INSERT INTO `floor` VALUES (225, 11, 11, 2);
INSERT INTO `floor` VALUES (226, 11, 12, 2);
INSERT INTO `floor` VALUES (227, 11, 13, 2);
INSERT INTO `floor` VALUES (228, 11, 14, 2);
INSERT INTO `floor` VALUES (229, 11, 15, 2);
INSERT INTO `floor` VALUES (230, 11, 16, 2);
INSERT INTO `floor` VALUES (231, 11, 17, 2);
INSERT INTO `floor` VALUES (232, 11, 18, 2);
INSERT INTO `floor` VALUES (233, 11, 19, 2);
INSERT INTO `floor` VALUES (234, 11, 20, 2);
INSERT INTO `floor` VALUES (235, 11, 21, 2);
INSERT INTO `floor` VALUES (236, 11, 22, 2);
INSERT INTO `floor` VALUES (237, 11, 23, 2);
INSERT INTO `floor` VALUES (238, 11, 24, 2);
INSERT INTO `floor` VALUES (239, 11, 25, 2);
INSERT INTO `floor` VALUES (240, 11, 26, 2);
INSERT INTO `floor` VALUES (241, 11, 27, 2);
INSERT INTO `floor` VALUES (242, 11, 28, 2);
INSERT INTO `floor` VALUES (243, 11, 29, 2);
INSERT INTO `floor` VALUES (244, 11, 30, 2);
INSERT INTO `floor` VALUES (245, 11, 31, 2);
INSERT INTO `floor` VALUES (246, 11, 32, 2);
INSERT INTO `floor` VALUES (247, 11, 33, 2);
INSERT INTO `floor` VALUES (248, 11, 34, 2);
INSERT INTO `floor` VALUES (249, 11, 35, 2);
INSERT INTO `floor` VALUES (250, 11, 36, 2);
INSERT INTO `floor` VALUES (251, 11, 37, 2);
INSERT INTO `floor` VALUES (252, 11, 38, 2);
INSERT INTO `floor` VALUES (253, 12, 1, 2);
INSERT INTO `floor` VALUES (254, 12, 2, 2);
INSERT INTO `floor` VALUES (255, 12, 3, 2);
INSERT INTO `floor` VALUES (256, 12, 4, 2);
INSERT INTO `floor` VALUES (257, 12, 5, 2);
INSERT INTO `floor` VALUES (258, 12, 6, 2);
INSERT INTO `floor` VALUES (259, 12, 7, 2);
INSERT INTO `floor` VALUES (260, 12, 8, 2);
INSERT INTO `floor` VALUES (261, 12, 9, 2);
INSERT INTO `floor` VALUES (262, 12, 10, 2);
INSERT INTO `floor` VALUES (263, 12, 11, 2);
INSERT INTO `floor` VALUES (264, 12, 12, 2);
INSERT INTO `floor` VALUES (265, 12, 13, 2);
INSERT INTO `floor` VALUES (266, 12, 14, 2);
INSERT INTO `floor` VALUES (267, 12, 15, 2);
INSERT INTO `floor` VALUES (268, 12, 16, 2);
INSERT INTO `floor` VALUES (269, 12, 17, 2);
INSERT INTO `floor` VALUES (270, 12, 18, 2);
INSERT INTO `floor` VALUES (271, 12, 19, 2);
INSERT INTO `floor` VALUES (272, 12, 20, 2);
INSERT INTO `floor` VALUES (273, 12, 21, 2);
INSERT INTO `floor` VALUES (274, 12, 22, 2);
INSERT INTO `floor` VALUES (275, 12, 23, 2);
INSERT INTO `floor` VALUES (276, 12, 24, 2);
INSERT INTO `floor` VALUES (277, 12, 25, 2);
INSERT INTO `floor` VALUES (278, 12, 26, 2);
INSERT INTO `floor` VALUES (279, 12, 27, 2);
INSERT INTO `floor` VALUES (280, 12, 28, 2);
INSERT INTO `floor` VALUES (281, 12, 29, 2);
INSERT INTO `floor` VALUES (282, 12, 30, 2);
INSERT INTO `floor` VALUES (283, 12, 31, 2);
INSERT INTO `floor` VALUES (284, 12, 32, 2);
INSERT INTO `floor` VALUES (285, 12, 33, 2);
INSERT INTO `floor` VALUES (286, 12, 34, 2);
INSERT INTO `floor` VALUES (287, 12, 35, 2);
INSERT INTO `floor` VALUES (288, 12, 36, 2);
INSERT INTO `floor` VALUES (289, 12, 37, 2);
INSERT INTO `floor` VALUES (290, 12, 38, 2);
INSERT INTO `floor` VALUES (291, 13, 1, 2);
INSERT INTO `floor` VALUES (292, 13, 2, 2);
INSERT INTO `floor` VALUES (293, 13, 3, 2);
INSERT INTO `floor` VALUES (294, 13, 4, 2);
INSERT INTO `floor` VALUES (295, 13, 5, 2);
INSERT INTO `floor` VALUES (296, 13, 6, 2);
INSERT INTO `floor` VALUES (297, 13, 7, 2);
INSERT INTO `floor` VALUES (298, 13, 8, 2);
INSERT INTO `floor` VALUES (299, 13, 9, 2);
INSERT INTO `floor` VALUES (300, 13, 10, 2);
INSERT INTO `floor` VALUES (301, 13, 11, 2);
INSERT INTO `floor` VALUES (302, 13, 12, 2);
INSERT INTO `floor` VALUES (303, 13, 13, 2);
INSERT INTO `floor` VALUES (304, 13, 14, 2);
INSERT INTO `floor` VALUES (305, 13, 15, 2);
INSERT INTO `floor` VALUES (306, 13, 16, 2);
INSERT INTO `floor` VALUES (307, 13, 17, 2);
INSERT INTO `floor` VALUES (308, 13, 18, 2);
INSERT INTO `floor` VALUES (309, 13, 19, 2);
INSERT INTO `floor` VALUES (310, 13, 20, 2);
INSERT INTO `floor` VALUES (311, 13, 21, 2);
INSERT INTO `floor` VALUES (312, 13, 22, 2);
INSERT INTO `floor` VALUES (313, 13, 23, 2);
INSERT INTO `floor` VALUES (314, 13, 24, 2);
INSERT INTO `floor` VALUES (315, 13, 25, 2);
INSERT INTO `floor` VALUES (316, 13, 26, 2);
INSERT INTO `floor` VALUES (317, 13, 27, 2);
INSERT INTO `floor` VALUES (318, 13, 28, 2);
INSERT INTO `floor` VALUES (319, 13, 29, 2);
INSERT INTO `floor` VALUES (320, 13, 30, 2);
INSERT INTO `floor` VALUES (321, 13, 31, 2);
INSERT INTO `floor` VALUES (322, 13, 32, 2);
INSERT INTO `floor` VALUES (323, 13, 33, 2);
INSERT INTO `floor` VALUES (324, 13, 34, 2);
INSERT INTO `floor` VALUES (325, 13, 35, 2);
INSERT INTO `floor` VALUES (326, 13, 36, 2);
INSERT INTO `floor` VALUES (327, 13, 37, 2);
INSERT INTO `floor` VALUES (328, 13, 38, 2);
INSERT INTO `floor` VALUES (329, 14, 1, 2);
INSERT INTO `floor` VALUES (330, 14, 2, 2);
INSERT INTO `floor` VALUES (331, 14, 3, 2);
INSERT INTO `floor` VALUES (332, 14, 4, 2);
INSERT INTO `floor` VALUES (333, 14, 5, 2);
INSERT INTO `floor` VALUES (334, 14, 6, 2);
INSERT INTO `floor` VALUES (335, 14, 7, 2);
INSERT INTO `floor` VALUES (336, 14, 8, 2);
INSERT INTO `floor` VALUES (337, 14, 9, 2);
INSERT INTO `floor` VALUES (338, 14, 10, 2);
INSERT INTO `floor` VALUES (339, 14, 11, 2);
INSERT INTO `floor` VALUES (340, 14, 12, 2);
INSERT INTO `floor` VALUES (341, 14, 13, 2);
INSERT INTO `floor` VALUES (342, 14, 14, 2);
INSERT INTO `floor` VALUES (343, 14, 15, 2);
INSERT INTO `floor` VALUES (344, 14, 16, 2);
INSERT INTO `floor` VALUES (345, 14, 17, 2);
INSERT INTO `floor` VALUES (346, 14, 18, 2);
INSERT INTO `floor` VALUES (347, 14, 19, 2);
INSERT INTO `floor` VALUES (348, 14, 20, 2);
INSERT INTO `floor` VALUES (349, 14, 21, 2);
INSERT INTO `floor` VALUES (350, 14, 22, 2);
INSERT INTO `floor` VALUES (351, 14, 23, 2);
INSERT INTO `floor` VALUES (352, 14, 24, 2);
INSERT INTO `floor` VALUES (353, 14, 25, 2);
INSERT INTO `floor` VALUES (354, 14, 26, 2);
INSERT INTO `floor` VALUES (355, 14, 27, 2);
INSERT INTO `floor` VALUES (356, 14, 28, 2);
INSERT INTO `floor` VALUES (357, 14, 29, 2);
INSERT INTO `floor` VALUES (358, 14, 30, 2);
INSERT INTO `floor` VALUES (359, 14, 31, 2);
INSERT INTO `floor` VALUES (360, 14, 32, 2);
INSERT INTO `floor` VALUES (361, 14, 33, 2);
INSERT INTO `floor` VALUES (362, 14, 34, 2);
INSERT INTO `floor` VALUES (363, 14, 35, 2);
INSERT INTO `floor` VALUES (364, 14, 36, 2);
INSERT INTO `floor` VALUES (365, 14, 37, 2);
INSERT INTO `floor` VALUES (366, 14, 38, 2);
INSERT INTO `floor` VALUES (367, 15, 1, 2);
INSERT INTO `floor` VALUES (368, 15, 2, 2);
INSERT INTO `floor` VALUES (369, 15, 3, 2);
INSERT INTO `floor` VALUES (370, 15, 4, 2);
INSERT INTO `floor` VALUES (371, 15, 5, 2);
INSERT INTO `floor` VALUES (372, 15, 6, 2);
INSERT INTO `floor` VALUES (373, 15, 7, 2);
INSERT INTO `floor` VALUES (374, 15, 8, 2);
INSERT INTO `floor` VALUES (375, 15, 9, 2);
INSERT INTO `floor` VALUES (376, 15, 10, 2);
INSERT INTO `floor` VALUES (377, 15, 11, 2);
INSERT INTO `floor` VALUES (378, 15, 12, 2);
INSERT INTO `floor` VALUES (379, 15, 13, 2);
INSERT INTO `floor` VALUES (380, 15, 14, 2);
INSERT INTO `floor` VALUES (381, 15, 15, 2);
INSERT INTO `floor` VALUES (382, 15, 16, 2);
INSERT INTO `floor` VALUES (383, 15, 17, 2);
INSERT INTO `floor` VALUES (384, 15, 18, 2);
INSERT INTO `floor` VALUES (385, 15, 19, 2);
INSERT INTO `floor` VALUES (386, 15, 20, 2);
INSERT INTO `floor` VALUES (387, 15, 21, 2);
INSERT INTO `floor` VALUES (388, 15, 22, 2);
INSERT INTO `floor` VALUES (389, 15, 23, 2);
INSERT INTO `floor` VALUES (390, 15, 24, 2);
INSERT INTO `floor` VALUES (391, 15, 25, 2);
INSERT INTO `floor` VALUES (392, 15, 26, 2);
INSERT INTO `floor` VALUES (393, 15, 27, 2);
INSERT INTO `floor` VALUES (394, 15, 28, 2);
INSERT INTO `floor` VALUES (395, 15, 29, 2);
INSERT INTO `floor` VALUES (396, 15, 30, 2);
INSERT INTO `floor` VALUES (397, 15, 31, 2);
INSERT INTO `floor` VALUES (398, 15, 32, 2);
INSERT INTO `floor` VALUES (399, 15, 33, 2);
INSERT INTO `floor` VALUES (400, 15, 34, 2);
INSERT INTO `floor` VALUES (401, 15, 35, 2);
INSERT INTO `floor` VALUES (402, 15, 36, 2);
INSERT INTO `floor` VALUES (403, 15, 37, 2);
INSERT INTO `floor` VALUES (404, 15, 38, 2);
INSERT INTO `floor` VALUES (405, 17, 1, 4);
INSERT INTO `floor` VALUES (406, 17, 2, 4);
INSERT INTO `floor` VALUES (407, 17, 3, 4);
INSERT INTO `floor` VALUES (408, 17, 4, 4);
INSERT INTO `floor` VALUES (409, 17, 5, 4);
INSERT INTO `floor` VALUES (410, 17, 6, 4);
INSERT INTO `floor` VALUES (411, 17, 7, 4);
INSERT INTO `floor` VALUES (412, 17, 8, 4);
INSERT INTO `floor` VALUES (413, 17, 9, 4);
INSERT INTO `floor` VALUES (414, 17, 10, 4);
INSERT INTO `floor` VALUES (415, 17, 11, 4);
INSERT INTO `floor` VALUES (416, 17, 12, 4);
INSERT INTO `floor` VALUES (417, 17, 13, 4);
INSERT INTO `floor` VALUES (418, 17, 14, 4);
INSERT INTO `floor` VALUES (419, 17, 15, 4);
INSERT INTO `floor` VALUES (420, 17, 16, 4);
INSERT INTO `floor` VALUES (421, 17, 17, 4);
INSERT INTO `floor` VALUES (422, 17, 18, 4);
INSERT INTO `floor` VALUES (423, 17, 19, 4);
INSERT INTO `floor` VALUES (424, 17, 20, 4);
INSERT INTO `floor` VALUES (425, 18, 1, 4);
INSERT INTO `floor` VALUES (426, 18, 2, 4);
INSERT INTO `floor` VALUES (427, 18, 3, 4);
INSERT INTO `floor` VALUES (428, 18, 4, 4);
INSERT INTO `floor` VALUES (429, 18, 5, 4);
INSERT INTO `floor` VALUES (430, 18, 6, 4);
INSERT INTO `floor` VALUES (431, 18, 7, 4);
INSERT INTO `floor` VALUES (432, 18, 8, 4);
INSERT INTO `floor` VALUES (433, 18, 9, 4);
INSERT INTO `floor` VALUES (434, 18, 10, 4);
INSERT INTO `floor` VALUES (435, 18, 11, 4);
INSERT INTO `floor` VALUES (436, 18, 12, 4);
INSERT INTO `floor` VALUES (437, 18, 13, 4);
INSERT INTO `floor` VALUES (438, 18, 14, 4);
INSERT INTO `floor` VALUES (439, 18, 15, 4);
INSERT INTO `floor` VALUES (440, 18, 16, 4);
INSERT INTO `floor` VALUES (441, 18, 17, 4);
INSERT INTO `floor` VALUES (442, 18, 18, 4);
INSERT INTO `floor` VALUES (443, 18, 19, 4);
INSERT INTO `floor` VALUES (444, 18, 20, 4);
INSERT INTO `floor` VALUES (445, 19, 1, 4);
INSERT INTO `floor` VALUES (446, 19, 2, 4);
INSERT INTO `floor` VALUES (447, 19, 3, 4);
INSERT INTO `floor` VALUES (448, 19, 4, 4);
INSERT INTO `floor` VALUES (449, 19, 5, 4);
INSERT INTO `floor` VALUES (450, 19, 6, 4);
INSERT INTO `floor` VALUES (451, 19, 7, 4);
INSERT INTO `floor` VALUES (452, 19, 8, 4);
INSERT INTO `floor` VALUES (453, 19, 9, 4);
INSERT INTO `floor` VALUES (454, 19, 10, 4);
INSERT INTO `floor` VALUES (455, 19, 11, 4);
INSERT INTO `floor` VALUES (456, 19, 12, 4);
INSERT INTO `floor` VALUES (457, 19, 13, 4);
INSERT INTO `floor` VALUES (458, 19, 14, 4);
INSERT INTO `floor` VALUES (459, 19, 15, 4);
INSERT INTO `floor` VALUES (460, 19, 16, 4);
INSERT INTO `floor` VALUES (461, 19, 17, 4);
INSERT INTO `floor` VALUES (462, 19, 18, 4);
INSERT INTO `floor` VALUES (463, 19, 19, 4);
INSERT INTO `floor` VALUES (464, 19, 20, 4);
INSERT INTO `floor` VALUES (465, 20, 1, 4);
INSERT INTO `floor` VALUES (466, 20, 2, 4);
INSERT INTO `floor` VALUES (467, 20, 3, 4);
INSERT INTO `floor` VALUES (468, 20, 4, 4);
INSERT INTO `floor` VALUES (469, 20, 5, 4);
INSERT INTO `floor` VALUES (470, 20, 6, 4);
INSERT INTO `floor` VALUES (471, 20, 7, 4);
INSERT INTO `floor` VALUES (472, 20, 8, 4);
INSERT INTO `floor` VALUES (473, 20, 9, 4);
INSERT INTO `floor` VALUES (474, 20, 10, 4);
INSERT INTO `floor` VALUES (475, 20, 11, 4);
INSERT INTO `floor` VALUES (476, 20, 12, 4);
INSERT INTO `floor` VALUES (477, 20, 13, 4);
INSERT INTO `floor` VALUES (478, 20, 14, 4);
INSERT INTO `floor` VALUES (479, 20, 15, 4);
INSERT INTO `floor` VALUES (480, 20, 16, 4);
INSERT INTO `floor` VALUES (481, 20, 17, 4);
INSERT INTO `floor` VALUES (482, 20, 18, 4);
INSERT INTO `floor` VALUES (483, 20, 19, 4);
INSERT INTO `floor` VALUES (484, 20, 20, 4);

-- ----------------------------
-- Table structure for freight_basis
-- ----------------------------
DROP TABLE IF EXISTS `freight_basis`;
CREATE TABLE `freight_basis`  (
  `freight_basis_id` int NOT NULL AUTO_INCREMENT COMMENT '1、水费；2、电费；3、物业费',
  `price` int NOT NULL COMMENT '单价*100，以整数保存',
  `intro` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '费用介绍',
  `basis_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '费用名称',
  PRIMARY KEY (`freight_basis_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '计费标准' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of freight_basis
-- ----------------------------
INSERT INTO `freight_basis` VALUES (1, 180, '根据自来水公司规定水费1.8/吨', '水费');
INSERT INTO `freight_basis` VALUES (2, 350, '根据物业公司和业主商议物业费3.5元每平方米', '物业费');
INSERT INTO `freight_basis` VALUES (3, 54, '根据自来水公司规定水费0.54/吨', '电费');

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message`  (
  `message_id` int NOT NULL AUTO_INCREMENT,
  `message_userid` int NOT NULL,
  `message_content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `message_publish_time` datetime(0) NULL DEFAULT NULL,
  `message_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `message_browse` int NOT NULL DEFAULT 0 COMMENT '帖子浏览量',
  `message_like` int NOT NULL DEFAULT 0 COMMENT '帖子点赞量',
  `message_unlike` int NULL DEFAULT 0,
  PRIMARY KEY (`message_id`) USING BTREE,
  INDEX `message_userid`(`message_userid`) USING BTREE,
  CONSTRAINT `message_ibfk_1` FOREIGN KEY (`message_userid`) REFERENCES `user` (`userid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of message
-- ----------------------------
INSERT INTO `message` VALUES (3, 3, '测试01，测试功能接收参数', '2023-01-01 00:00:00', '测试01', 35, 2, 0);
INSERT INTO `message` VALUES (4, 3, '        JavaScript（简称JS）是一种运行在浏览器中的脚本语言，它可以让网页变得更加动态、交互和有趣。JS是网页开发的三大核心技术之一，与HTML和CSS相辅相成Deepl降重。HTML负责定义网页的内容，CSS负责指定网页的布局，而JS负责编写网页的行为。通过JS，可以实现以下功能：\n\n在网页上显示当前的日期和时间\n在用户点击按钮时弹出对话框\n在用户输入数据时进行验证和提示\n在用户滚动页面时改变网页的背景颜色\n在用户拖动元素时实现拖放效果\n在用户玩游戏时实现动画和音效\n等等\nJS不仅仅可以用于网页开发，还可以用于其他领域，例如：\n\n服务器端开发：通过Node.js平台，可以使用JS来编写服务器端的应用程序，处理网络请求、数据库操作、文件操作等。\n移动端开发：通过React Native框架，可以使用JS来编写跨平台的移动应用程序，运行在Android和iOS设备上。\n桌面端开发：通过Electron框架，可以使用JS来编写桌面应用程序，运行在Windows、Mac和Linux系统上。\n机器学习：通过TensorFlow.js库，可以使用JS来编写机器学习的模型和算法，实现人脸识别、图像分类、自然语言处理等功能。', '2023-12-11 02:41:52', 'javascript从入门到放弃', 65, 11, 2);
INSERT INTO `message` VALUES (5, 6, '当 <style> 标签有 scoped 属性时，它的 CSS 只作用于当前组件中的元素。\n它会为组件中所有的标签和class样式添加一个scoped标识，就像上面结果中的data-v-1b971ada。\n所以原因就很清楚了：因为动态添加的dom没有scoped添加的标识，没有跟testAdd的样式匹配起来，导致样式失效。\n解决方式\n\n推荐：去掉该组件的scoped\n\n每个组件的css并不会很多，当设计到动态添加dom，并为dom添加样式的时候，就可以去掉scoped，会比下面的方法方便很多。\n\n', '2023-12-15 03:18:53', '你不知道的vue', 3, 0, 0);
INSERT INTO `message` VALUES (6, 5, '一、Java语言历史\nJava的第一个开发工具包（JDK 1.0）JDK 1.1 JDK 1.2 JDK 1.3 JDK1.4。Java SE 5.0（内部版本号1.5.0） Java SE 6 Java7 Java8，我们不用最新的版本用最稳定的版本Java8，我们现在要学Java 涉及到JDK的安装JDK（Java Development Kit）称为Java开发包或Java开发工具，是一个编写Java的应用程序的程序开发环境。JDK是整个Java的核心，包括了Java运行环境（Java Runtime Environment），Java虚拟机 JVM，JRE是支持Java程序运行的标准环境 。JDK、JRE、JVM三者的关系，JDK包含了JRE同时包含了JVM、JRE是个运行环境，JDK是个开发环境。因此写Java程序的时候需要JDK，而运行Java程序的时候就需要JRE。而JDK里面已经包含了JRE，因此只要安装了JDK，就可以编辑Java程序，也可以正常运行Java程序。Windows系统，安装文件是.exe的文件，JDK也要安装因此JDK也是一个.exe的文件，并不会像其他软件一样生成快捷方式。\n\n二、Java语言特点\n简单性\n\n面向对象\n\n分布性\n\n编译性和解释性\n①　编译性\n语言执行时需要先进行编译就是编译型语言，现在的高级语言在执行时，计算机不识别这个代码文件，需要先进行编译，形成字节码文件让计算机可以识别，程序才可以运行。编译型语言，肯定会形成出新的文件。（文件类型区分？？？ 可以通过文件后缀区分文件，Java文件后缀是.java编译形成新的文件，新文件的后缀是.class类型）\n编译的过程\n原来文件——规则——生成新的文件（字节码文件）\n文件后缀 .java——javac（编译）——.class文件\n执行的过程\njavac A.java（文件名+后缀）\n\n②　解释性\n两个人交流时，中间的翻译（解释）.class文件计算机不认识而JVM就是.class和计算机之间的（翻译）因此Java 是解释性语言也是编译性语言。\n执行class文件——翻译器（JVM）翻译给电脑\njava A 文件名（不加后缀）\n\n可移植性\n跨平台可以运行再不同的操作系统上\n', '2023-12-15 03:21:16', 'Java基础篇——从入门到入土', 3, 0, 0);
INSERT INTO `message` VALUES (7, 4, '\n\n一、什么是Node.js?Node.js 是一个开源与跨平台的 JavaScript 运行时环境, 在浏览器外运行 V8 JavaScript 引擎（Google Chrome 的内核），利用事件驱动、非阻塞和异步输入输出模型等技术提高性能。可以理解为 Node.js 就是一个服务器端的、非阻塞式I/O的、事件驱动的JavaScript运行环境非阻塞异步Nodejs采用了非阻塞型I/O机制，在做I/O操作的时候不会造成任何的阻塞，当完成之后，以时间的形式通知执行操作。例如在执行了访问数据库的代码之后，将立即转而执行其后面的代码，把数据库返回结果的处理代码放在回调函数中，从而提高了程序的执行效率。事件驱动事件驱动就是当进来一个新的请求的时，请求将会被压入一个事件队列中，然后通过一个循环来检测队列中的事件状态变化，如果检测到有状态变化的事件，那么就执行该事件对应的处理代码，一般都是回调函数\n\n二、Node.js的优缺点优点：处理高并发场景性能更佳；适合I/O密集型应用，指的是应用在运行极限时，CPU占用率仍然比较低，大部分时间是在做 I/O硬盘内存读写操作。因为Nodejs是单线程，带来的缺点有：不适合CPU密集型应用只支持单核CPU，不能充分利用CPU可靠性低，一旦代码某个环节崩溃，整个系统都崩溃\n\n三、Node.js的应用场景借助Nodejs的特点和弊端，其应用场景分类如下：\n\n善于I/O，不善于计算。因为Nodejs是一个单线程，如果计算（同步）太多，则会阻塞这个线程大量并发的I/O，应用程序内部并不需要进行非常复杂的处理与 websocket 配合，开发长连接的实时交互应用程序具体场景可以表现为如下：\n第一大类：用户表单收集系统、后台管理系统、实时交互系统、考试系统、联网软件、高并发量的web应用程序\n第二大类：基于web、canvas等多人联网游戏\n第三大类：基于web的多人实时聊天客户端、聊天室、图文直播第\n四大类：单页面浏览器应用程序', '2023-12-15 03:24:57', 'Node.js的应用场景', 1, 0, 0);
INSERT INTO `message` VALUES (8, 4, 'Ajax（Asynchronous JavaScript and XML）是一种用于在没有重载整个页面的情况下，从服务器异步获取数据并更新网页的网络技术。它的出现极大地提高了用户和网站的互动性和响应速度，因此成为了现代Web开发中不可或缺的技术。本文将指引零基础的读者学习Ajax，以下是具体步骤：\n\n步骤一：了解基本概念\n在开始学习Ajax之前，需要先了解一些基本概念：\n\n1. XMLHttpRequest对象：这是Ajax核心技术的实现基础。它是一种能够与服务器进行异步数据交互并接收响应的JavaScript API。\n\n2. 异步与同步：同步意味着当一个操作发生时，程序会等待该操作完成后再继续进行下一步；而异步则是指程序可以在操作正在执行的同时，继续进行下一步操作。\n\n3. JSON：JavaScript Object Notation（JavaScript对象表示法）是一种轻量级的数据交换格式。它易于人阅读和编写，同时也易于机器解析和生成。\n\n了解这些概念有助于我们理解Ajax技术的本质，并在后续的学习中更好地操作和应用。\n\n步骤二：学习HTML、CSS和JavaScript\n在学习Ajax之前，需要掌握HTML、CSS和JavaScript等基本的Web开发技术。HTML用于定义网页内容和结构，CSS用于样式设计和布局，而JavaScript则是实现网页交互与动态效果的语言。掌握这些基础知识可以为后续的Ajax学习打下坚实的基础。 可以给大家推荐一个让大家少走弯路的视频，满满干货：\n\n我愿称这个视频为《Ajax最强教学》，零基础入门少走99％的弯路！！！_哔哩哔哩_bilibili\n​www.bilibili.com/video/BV1z84y1u7gE/\n\n步骤三：实践Ajax\n实践是巩固Ajax技术的最好方式。以下是学习Ajax的具体步骤：\n\n1. 创建XMLHttpRequest对象。\n在JavaScript中使用Ajax技术，需要创建一个XMLHttpRequest对象。代码如下：\n\nvar xmlhttp; if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari   xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5   xmlhttp=new ActiveXObject(\"Microsoft.XMLHTTP\"); }\n2. 发送HTTP请求。\n使用Ajax发送HTTP请求，可以向服务器请求数据。发送HTTP请求的方式通常有两种：GET和POST。GET一般用于从服务器获取数据，而POST则是向服务器提交数据。以下是GET请求的代码实现：\n\n ``` xmlhttp.open(\"GET\",\"demo_get.asp\",true); xmlhttp.send(); ``` \n其中，“demo_get.asp”是服务器端提供的数据接口，true表示将请求设置为异步。\n\n3. 接收响应并处理。\n一旦服务器接收到请求并处理完毕，将会返回响应结果。我们可以检查响应状态码（例如200表示“OK”，404表示“未找到”等等）来判断请求是否成功。通过读取响应文本或响应XML，开发者可以解析出服务器端返回的数据并进行相应处理。以下是判断请求成功的代码：\n\n ``` xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById(\"myDiv\").innerHTML=xmlhttp.responseText; } } ``` \n其中，“myDiv”是一个HTML元素的ID，表示响应文本将显示在此元素内。\n\n步骤四：深入学习Ajax\n除了基本的Ajax技术之外，还有一些高级特性和技术细节需要了解和学习，例如：\n\n1. 跨域资源共享（CORS）：由于安全性考虑，浏览器会禁止跨域请求。CORS是解决跨域问题的一种常见方式。\n\n2. Promise：Promise是一种异步编程的解决方案，可以有效地防止“回调地狱”的情况发生。\n\n3. jQuery：jQuery是一个流行的JavaScript库，其中封装了一些方便的Ajax函数，使得开发者可以更快速和方便地实现Ajax。\n\n4. WebSocket：WebSocket是一种实现双向通信的网络协议，可以用于实时通信和推送服务。\n\n总结：\n以上就是学习Ajax的基本步骤，需要注意的是，Ajax是一种技术，而非规范，因此并没有一个标准的学习路线。不过，通过以上步骤的学习，读者可以初步掌握Ajax的基本知识和技能，进而在日后的开发中更加游刃有余。最后要提醒的是，实践是巩固Ajax技术的最好方式，希望读者在学习过程中能够多多动手实践，深入理解Ajax的本质和应用。', '2023-12-17 12:54:33', '从零开始学Ajax', 4, 0, 0);
INSERT INTO `message` VALUES (9, 13, 'MySQL 事务\n本文所说的 MySQL 事务都是指在 InnoDB 引擎下，MyISAM 引擎是不支持事务的。\n\n数据库事务指的是一组数据操作，事务内的操作要么就是全部成功，要么就是全部失败，什么都不做，其实不是没做，是可能做了一部分但是只要有一步失败，就要回滚所有操作，有点一不做二不休的意思。\n\n假设一个网购付款的操作，用户付款后要涉及到订单状态更新、扣库存以及其他一系列动作，这就是一个事务，如果一切正常那就相安无事，一旦中间有某个环节异常，那整个事务就要回滚，总不能更新了订单状态但是不扣库存吧，这问题就大了。\n\n事务具有原子性（Atomicity）、一致性（Consistency）、隔离性（Isolation）、持久性（Durability）四个特性，简称 ACID，缺一不可。今天要说的就是隔离性。\n\n概念说明\n以下几个概念是事务隔离级别要实际解决的问题，所以需要搞清楚都是什么意思。\n\n脏读\n\n脏读指的是读到了其他事务未提交的数据，未提交意味着这些数据可能会回滚，也就是可能最终不会存到数据库中，也就是不存在的数据。读到了并一定最终存在的数据，这就是脏读。\n\n可重复读\n\n可重复读指的是在一个事务内，最开始读到的数据和事务结束前的任意时刻读到的同一批数据都是一致的。通常针对数据更新（UPDATE）操作。\n\n不可重复读\n\n对比可重复读，不可重复读指的是在同一事务内，不同的时刻读到的同一批数据可能是不一样的，可能会受到其他事务的影响，比如其他事务改了这批数据并提交了。通常针对数据更新（UPDATE）操作。\n\n幻读\n\n幻读是针对数据插入（INSERT）操作来说的。假设事务A对某些行的内容作了更改，但是还未提交，此时事务B插入了与事务A更改前的记录相同的记录行，并且在事务A提交之前先提交了，而这时，在事务A中查询，会发现好像刚刚的更改对于某些数据未起作用，但其实是事务B刚插入进来的，让用户感觉很魔幻，感觉出现了幻觉，这就叫幻读。\n\n事务隔离级别\nSQL 标准定义了四种隔离级别，MySQL 全都支持。这四种隔离级别分别是：\n\n读未提交（READ UNCOMMITTED）\n读提交 （READ COMMITTED）\n可重复读 （REPEATABLE READ）\n串行化 （SERIALIZABLE）\n从上往下，隔离强度逐渐增强，性能逐渐变差。采用哪种隔离级别要根据系统需求权衡决定，其中，可重复读是 MySQL 的默认级别。\n\n事务隔离其实就是为了解决上面提到的脏读、不可重复读、幻读这几个问题，下面展示了 4 种隔离级别对这三个问题的解决程度。\n\n\n只有串行化的隔离级别解决了全部这 3 个问题，其他的 3 个隔离级别都有缺陷。\n\n一探究竟\n下面，我们来一一分析这 4 种隔离级别到底是怎么个意思。\n\n如何设置隔离级别\n\n我们可以通过以下语句查看当前数据库的隔离级别，通过下面语句可以看出我使用的 MySQL 的隔离级别是 REPEATABLE-READ，也就是可重复读，这也是 MySQL 的默认级别。\n\n# 查看事务隔离级别 5.7.20 之后\nshow variables like \'transaction_isolation\';\nSELECT @@transaction_isolation\n\n# 5.7.20 之后\nSELECT @@tx_isolation\nshow variables like \'tx_isolation\'\n\n+---------------+-----------------+\n| Variable_name | Value           |\n+---------------+-----------------+\n| tx_isolation  | REPEATABLE-READ |\n+---------------+-----------------+\n稍后，我们要修改数据库的隔离级别，所以先了解一下具体的修改方式。\n\n修改隔离级别的语句是：set [作用域] transaction isolation level [事务隔离级别]，\nSET [SESSION | GLOBAL] TRANSACTION ISOLATION LEVEL {READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SERIALIZABLE}。\n\n其中作用于可以是 SESSION 或者 GLOBAL，GLOBAL 是全局的，而 SESSION 只针对当前回话窗口。隔离级别是 {READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SERIALIZABLE} 这四种，不区分大小写。\n\n比如下面这个语句的意思是设置全局隔离级别为读提交级别。\n\nmysql> set global transaction isolation level read committed;\nMySQL 中执行事务\n\n事务的执行过程如下，以 begin 或者 start transaction 开始，然后执行一系列操作，最后要执行 commit 操作，事务才算结束。当然，如果进行回滚操作(rollback)，事务也会结束。\n\n\n需要注意的是，begin 命令并不代表事务的开始，事务开始于 begin 命令之后的第一条语句执行的时候。例如下面示例中，select * from xxx 才是事务的开始，\n\nbegin;\nselect * from xxx; \ncommit; -- 或者 rollback;\n另外，通过以下语句可以查询当前有多少事务正在运行。\n\nselect * from information_schema.innodb_trx;\n好了，重点来了，开始分析这几个隔离级别了。\n\n接下来我会用一张表来做一下验证，表结构简单如下：\n\nCREATE TABLE `user` (\n  `id` int(11) NOT NULL AUTO_INCREMENT,\n  `name` varchar(30) DEFAULT NULL,\n  `age` tinyint(4) DEFAULT NULL,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8\n初始只有一条记录：\n\nmysql> SELECT * FROM user;\n+----+-----------------+------+\n| id | name            | age  |\n+----+-----------------+------+\n|  1 | 古时的风筝        |    1 |\n+----+-----------------+------+\n读未提交\n\nMySQL 事务隔离其实是依靠锁来实现的，加锁自然会带来性能的损失。而读未提交隔离级别是不加锁的，所以它的性能是最好的，没有加锁、解锁带来的性能开销。但有利就有弊，这基本上就相当于裸奔啊，所以它连脏读的问题都没办法解决。\n\n任何事务对数据的修改都会第一时间暴露给其他事务，即使事务还没有提交。\n\n下面来做个简单实验验证一下，首先设置全局隔离级别为读未提交。\n\nset global transaction isolation level read uncommitted;\n设置完成后，只对之后新起的 session 才起作用，对已经启动 session 无效。如果用 shell 客户端那就要重新连接 MySQL，如果用 Navicat 那就要创建新的查询窗口。\n\n启动两个事务，分别为事务A和事务B，在事务A中使用 update 语句，修改 age 的值为10，初始是1 ，在执行完 update 语句之后，在事务B中查询 user 表，会看到 age 的值已经是 10 了，这时候事务A还没有提交，而此时事务B有可能拿着已经修改过的 age=10 去进行其他操作了。在事务B进行操作的过程中，很有可能事务A由于某些原因，进行了事务回滚操作，那其实事务B得到的就是脏数据了，拿着脏数据去进行其他的计算，那结果肯定也是有问题的。\n\n顺着时间轴往表示两事务中操作的执行顺序，重点看图中 age 字段的值。\n\n\n读未提交，其实就是可以读到其他事务未提交的数据，但没有办法保证你读到的数据最终一定是提交后的数据，如果中间发生回滚，那就会出现脏数据问题，读未提交没办法解决脏数据问题。更别提可重复读和幻读了，想都不要想。\n\n读提交\n\n既然读未提交没办法解决脏数据问题，那么就有了读提交。读提交就是一个事务只能读到其他事务已经提交过的数据，也就是其他事务调用 commit 命令之后的数据。那脏数据问题迎刃而解了。\n\n读提交事务隔离级别是大多数流行数据库的默认事务隔离界别，比如 Oracle，但是不是 MySQL 的默认隔离界别。\n\n我们继续来做一下验证，首先把事务隔离级别改为读提交级别。\n\nset global transaction isolation level read committed;\n之后需要重新打开新的 session 窗口，也就是新的 shell 窗口才可以。\n\n同样开启事务A和事务B两个事务，在事务A中使用 update 语句将 id=1 的记录行 age 字段改为 10。此时，在事务B中使用 select 语句进行查询，我们发现在事务A提交之前，事务B中查询到的记录 age 一直是1，直到事务A提交，此时在事务B中 select 查询，发现 age 的值已经是 10 了。\n\n这就出现了一个问题，在同一事务中(本例中的事务B)，事务的不同时刻同样的查询条件，查询出来的记录内容是不一样的，事务A的提交影响了事务B的查询结果，这就是不可重复读，也就是读提交隔离级别。\n\n\n每个 select 语句都有自己的一份快照，而不是一个事务一份，所以在不同的时刻，查询出来的数据可能是不一致的。\n\n读提交解决了脏读的问题，但是无法做到可重复读，也没办法解决幻读。\n\n可重复读\n\n可重复是对比不可重复而言的，上面说不可重复读是指同一事物不同时刻读到的数据值可能不一致。而可重复读是指，事务不会读到其他事务对已有数据的修改，及时其他事务已提交，也就是说，事务开始时读到的已有数据是什么，在事务提交前的任意时刻，这些数据的值都是一样的。但是，对于其他事务新插入的数据是可以读到的，这也就引发了幻读问题。\n\n同样的，需改全局隔离级别为可重复读级别。\n\nset global transaction isolation level repeatable read;\n在这个隔离级别下，启动两个事务，两个事务同时开启。\n\n首先看一下可重复读的效果，事务A启动后修改了数据，并且在事务B之前提交，事务B在事务开始和事务A提交之后两个时间节点都读取的数据相同，已经可以看出可重复读的效果。\n\n\n可重复读做到了，这只是针对已有行的更改操作有效，但是对于新插入的行记录，就没这么幸运了，幻读就这么产生了。我们看一下这个过程：\n\n事务A开始后，执行 update 操作，将 age = 1 的记录的 name 改为“风筝2号”；\n\n事务B开始后，在事务执行完 update 后，执行 insert 操作，插入记录 age =1，name = 古时的风筝，这和事务A修改的那条记录值相同，然后提交。\n\n事务B提交后，事务A中执行 select，查询 age=1 的数据，这时，会发现多了一行，并且发现还有一条 name = 古时的风筝，age = 1 的记录，这其实就是事务B刚刚插入的，这就是幻读。\n\n\n要说明的是，当你在 MySQL 中测试幻读的时候，并不会出现上图的结果，幻读并没有发生，MySQL 的可重复读隔离级别其实解决了幻读问题，这会在后面的内容说明\n\n串行化\n\n串行化是4种事务隔离级别中隔离效果最好的，解决了脏读、可重复读、幻读的问题，但是效果最差，它将事务的执行变为顺序执行，与其他三个隔离级别相比，它就相当于单线程，后一个事务的执行必须等待前一个事务结束。\n\nMySQL 中是如何实现事务隔离的\n首先说读未提交，它是性能最好，也可以说它是最野蛮的方式，因为它压根儿就不加锁，所以根本谈不上什么隔离效果，可以理解为没有隔离。\n\n再来说串行化。读的时候加共享锁，也就是其他事务可以并发读，但是不能写。写的时候加排它锁，其他事务不能并发写也不能并发读。\n\n最后说读提交和可重复读。这两种隔离级别是比较复杂的，既要允许一定的并发，又想要兼顾的解决问题。\n\n实现可重复读\n\n为了解决不可重复读，或者为了实现可重复读，MySQL 采用了 MVVC (多版本并发控制) 的方式。\n\n我们在数据库表中看到的一行记录可能实际上有多个版本，每个版本的记录除了有数据本身外，还要有一个表示版本的字段，记为 row trx_id，而这个字段就是使其产生的事务的 id，事务 ID 记为 transaction id，它在事务开始的时候向事务系统申请，按时间先后顺序递增。\n\n\n按照上面这张图理解，一行记录现在有 3 个版本，每一个版本都记录这使其产生的事务 ID，比如事务A的transaction id 是100，那么版本1的row trx_id 就是 100，同理版本2和版本3。\n\n在上面介绍读提交和可重复读的时候都提到了一个词，叫做快照，学名叫做一致性视图，这也是可重复读和不可重复读的关键，可重复读是在事务开始的时候生成一个当前事务全局性的快照，而读提交则是每次执行语句的时候都重新生成一次快照。\n\n对于一个快照来说，它能够读到那些版本数据，要遵循以下规则：\n\n当前事务内的更新，可以读到；\n版本未提交，不能读到；\n版本已提交，但是却在快照创建后提交的，不能读到；\n版本已提交，且是在快照创建前提交的，可以读到；\n利用上面的规则，再返回去套用到读提交和可重复读的那两张图上就很清晰了。还是要强调，两者主要的区别就是在快照的创建上，可重复读仅在事务开始是创建一次，而读提交每次执行语句的时候都要重新创建一次。\n\n并发写问题\n\n存在这的情况，两个事务，对同一条数据做修改。最后结果应该是哪个事务的结果呢，肯定要是时间靠后的那个对不对。并且更新之前要先读数据，这里所说的读和上面说到的读不一样，更新之前的读叫做“当前读”，总是当前版本的数据，也就是多版本中最新一次提交的那版。\n\n假设事务A执行 update 操作， update 的时候要对所修改的行加行锁，这个行锁会在提交之后才释放。而在事务A提交之前，事务B也想 update 这行数据，于是申请行锁，但是由于已经被事务A占有，事务B是申请不到的，此时，事务B就会一直处于等待状态，直到事务A提交，事务B才能继续执行，如果事务A的时间太长，那么事务B很有可能出现超时异常。如下图所示。\n\n\n加锁的过程要分有索引和无索引两种情况，比如下面这条语句\n\nupdate user set age=11 where id = 1\nid 是这张表的主键，是有索引的情况，那么 MySQL 直接就在索引数中找到了这行数据，然后干净利落的加上行锁就可以了。\n\n而下面这条语句\n\nupdate user set age=11 where age=10\n表中并没有为 age 字段设置索引，所以， MySQL 无法直接定位到这行数据。那怎么办呢，当然也不是加表锁了。MySQL 会为这张表中所有行加行锁，没错，是所有行。但是呢，在加上行锁后，MySQL 会进行一遍过滤，发现不满足的行就释放锁，最终只留下符合条件的行。虽然最终只为符合条件的行加了锁，但是这一锁一释放的过程对性能也是影响极大的。所以，如果是大表的话，建议合理设计索引，如果真的出现这种情况，那很难保证并发度。\n\n解决幻读\n\n上面介绍可重复读的时候，那张图里标示着出现幻读的地方实际上在 MySQL 中并不会出现，MySQL 已经在可重复读隔离级别下解决了幻读的问题。\n\n前面刚说了并发写问题的解决方式就是行锁，而解决幻读用的也是锁，叫做间隙锁，MySQL 把行锁和间隙锁合并在一起，解决了并发写和幻读的问题，这个锁叫做 Next-Key锁。\n\n假设现在表中有两条记录，并且 age 字段已经添加了索引，两条记录 age 的值分别为 10 和 30。\n\n\n此时，在数据库中会为索引维护一套B+树，用来快速定位行记录。B+索引树是有序的，所以会把这张表的索引分割成几个区间。\n\n\n如图所示，分成了3 个区间，(负无穷,10]、(10,30]、(30,正无穷]，在这3个区间是可以加间隙锁的。\n\n之后，我用下面的两个事务演示一下加锁过程。\n\n\n在事务A提交之前，事务B的插入操作只能等待，这就是间隙锁起得作用。当事务A执行update user set name=\'风筝2号’ where age = 10; 的时候，由于条件 where age = 10 ，数据库不仅在 age =10 的行上添加了行锁，而且在这条记录的两边，也就是(负无穷,10]、(10,30]这两个区间加了间隙锁，从而导致事务B插入操作无法完成，只能等待事务A提交。不仅插入 age = 10 的记录需要等待事务A提交，age<10、10<age<30 的记录页无法完成，而大于等于30的记录则不受影响，这足以解决幻读问题了。\n\n这是有索引的情况，如果 age 不是索引列，那么数据库会为整个表加上间隙锁。所以，如果是没有索引的话，不管 age 是否大于等于30，都要等待事务A提交才可以成功插入。\n\n总结\nMySQL 的 InnoDB 引擎才支持事务，其中可重复读是默认的隔离级别。\n\n读未提交和串行化基本上是不需要考虑的隔离级别，前者不加锁限制，后者相当于单线程执行，效率太差。\n\n读提交解决了脏读问题，行锁解决了并发更新的问题。并且 MySQL 在可重复读级别解决了幻读问题，是通过行锁和间隙锁的组合 Next-Key 锁实现的', '2023-12-17 13:02:45', 'MySQL事务隔离级别和实现原理', 1, 0, 0);

-- ----------------------------
-- Table structure for pay
-- ----------------------------
DROP TABLE IF EXISTS `pay`;
CREATE TABLE `pay`  (
  `pay_id` int NOT NULL AUTO_INCREMENT,
  `pay_room_id` int NOT NULL,
  `pay` double NOT NULL,
  `pay_date` date NOT NULL,
  `pay_type` int NOT NULL COMMENT '支付的费用类型',
  PRIMARY KEY (`pay_id`) USING BTREE,
  INDEX `pay_room_id`(`pay_room_id`) USING BTREE,
  INDEX `pay_type`(`pay_type`) USING BTREE,
  CONSTRAINT `pay_ibfk_1` FOREIGN KEY (`pay_room_id`) REFERENCES `room` (`room_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `pay_ibfk_2` FOREIGN KEY (`pay_type`) REFERENCES `freight_basis` (`freight_basis_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of pay
-- ----------------------------
INSERT INTO `pay` VALUES (1, 25, 8000, '2021-01-01', 1);
INSERT INTO `pay` VALUES (5, 25, 20000, '2023-01-01', 1);
INSERT INTO `pay` VALUES (8, 28, 2000, '2023-01-01', 1);
INSERT INTO `pay` VALUES (9, 28, 2000, '2022-01-01', 1);
INSERT INTO `pay` VALUES (10, 25, 2000, '2023-12-13', 2);
INSERT INTO `pay` VALUES (11, 25, 2000, '2023-12-17', 1);
INSERT INTO `pay` VALUES (12, 25, 3000, '2023-12-17', 2);
INSERT INTO `pay` VALUES (13, 25, 40000, '2023-12-17', 2);
INSERT INTO `pay` VALUES (14, 25, 10000, '2023-12-17', 1);

-- ----------------------------
-- Table structure for room
-- ----------------------------
DROP TABLE IF EXISTS `room`;
CREATE TABLE `room`  (
  `room_id` int NOT NULL AUTO_INCREMENT,
  `room_floor_id` int NOT NULL COMMENT '对应楼层编号',
  `built_up_area` smallint NOT NULL COMMENT '建筑面积',
  `room_status` smallint NOT NULL COMMENT '房间状态：1、自住；2、出租；3、未居住；4、未售出；5、公共空间',
  `room_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '13-03-03,13栋3层3号',
  PRIMARY KEY (`room_id`) USING BTREE,
  INDEX `room_floor_id`(`room_floor_id`) USING BTREE,
  CONSTRAINT `room_ibfk_1` FOREIGN KEY (`room_floor_id`) REFERENCES `floor` (`floor_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1136 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of room
-- ----------------------------
INSERT INTO `room` VALUES (25, 9, 360, 1, '1-1-1');
INSERT INTO `room` VALUES (26, 9, 360, 1, '1-1-2');
INSERT INTO `room` VALUES (27, 10, 360, 1, '1-2-1');
INSERT INTO `room` VALUES (28, 10, 360, 1, '1-2-2');
INSERT INTO `room` VALUES (29, 11, 360, 1, '1-3-1');
INSERT INTO `room` VALUES (30, 11, 360, 1, '1-3-2');
INSERT INTO `room` VALUES (31, 12, 360, 1, '1-4-1');
INSERT INTO `room` VALUES (32, 12, 360, 1, '1-4-2');
INSERT INTO `room` VALUES (33, 13, 360, 1, '1-5-1');
INSERT INTO `room` VALUES (34, 13, 360, 1, '1-5-2');
INSERT INTO `room` VALUES (35, 14, 360, 4, '1-6-1');
INSERT INTO `room` VALUES (36, 14, 360, 4, '1-6-2');
INSERT INTO `room` VALUES (37, 15, 360, 4, '1-7-1');
INSERT INTO `room` VALUES (38, 15, 360, 4, '1-7-2');
INSERT INTO `room` VALUES (39, 16, 360, 4, '1-8-1');
INSERT INTO `room` VALUES (40, 16, 360, 4, '1-8-2');
INSERT INTO `room` VALUES (41, 17, 360, 4, '1-9-1');
INSERT INTO `room` VALUES (42, 17, 360, 4, '1-9-2');
INSERT INTO `room` VALUES (43, 18, 360, 4, '1-10-1');
INSERT INTO `room` VALUES (44, 18, 360, 4, '1-10-2');
INSERT INTO `room` VALUES (45, 19, 360, 4, '1-11-1');
INSERT INTO `room` VALUES (46, 19, 360, 4, '1-11-2');
INSERT INTO `room` VALUES (47, 20, 360, 4, '1-12-1');
INSERT INTO `room` VALUES (48, 20, 360, 4, '1-12-2');
INSERT INTO `room` VALUES (49, 21, 360, 4, '1-13-1');
INSERT INTO `room` VALUES (50, 21, 360, 4, '1-13-2');
INSERT INTO `room` VALUES (51, 22, 360, 4, '1-14-1');
INSERT INTO `room` VALUES (52, 22, 360, 4, '1-14-2');
INSERT INTO `room` VALUES (53, 23, 360, 4, '1-15-1');
INSERT INTO `room` VALUES (54, 23, 360, 4, '1-15-2');
INSERT INTO `room` VALUES (55, 24, 360, 4, '1-16-1');
INSERT INTO `room` VALUES (56, 24, 360, 4, '1-16-2');
INSERT INTO `room` VALUES (57, 25, 360, 4, '1-17-1');
INSERT INTO `room` VALUES (58, 25, 360, 4, '1-17-2');
INSERT INTO `room` VALUES (59, 26, 360, 4, '1-18-1');
INSERT INTO `room` VALUES (60, 26, 360, 4, '1-18-2');
INSERT INTO `room` VALUES (61, 27, 360, 4, '1-19-1');
INSERT INTO `room` VALUES (62, 27, 360, 4, '1-19-2');
INSERT INTO `room` VALUES (63, 28, 360, 4, '1-20-1');
INSERT INTO `room` VALUES (64, 28, 360, 4, '1-20-2');
INSERT INTO `room` VALUES (65, 29, 360, 4, '1-21-1');
INSERT INTO `room` VALUES (66, 29, 360, 4, '1-21-2');
INSERT INTO `room` VALUES (67, 30, 360, 4, '1-22-1');
INSERT INTO `room` VALUES (68, 30, 360, 4, '1-22-2');
INSERT INTO `room` VALUES (69, 31, 360, 4, '1-23-1');
INSERT INTO `room` VALUES (70, 31, 360, 4, '1-23-2');
INSERT INTO `room` VALUES (71, 32, 360, 4, '1-24-1');
INSERT INTO `room` VALUES (72, 32, 360, 4, '1-24-2');
INSERT INTO `room` VALUES (73, 33, 360, 4, '1-25-1');
INSERT INTO `room` VALUES (74, 33, 360, 4, '1-25-2');
INSERT INTO `room` VALUES (75, 34, 360, 4, '1-26-1');
INSERT INTO `room` VALUES (76, 34, 360, 4, '1-26-2');
INSERT INTO `room` VALUES (77, 35, 360, 4, '1-27-1');
INSERT INTO `room` VALUES (78, 35, 360, 4, '1-27-2');
INSERT INTO `room` VALUES (79, 36, 360, 4, '1-28-1');
INSERT INTO `room` VALUES (80, 36, 360, 4, '1-28-2');
INSERT INTO `room` VALUES (81, 37, 360, 4, '2-1-1');
INSERT INTO `room` VALUES (82, 37, 360, 4, '2-1-2');
INSERT INTO `room` VALUES (83, 38, 360, 4, '2-2-1');
INSERT INTO `room` VALUES (84, 38, 360, 4, '2-2-2');
INSERT INTO `room` VALUES (85, 39, 360, 4, '2-3-1');
INSERT INTO `room` VALUES (86, 39, 360, 4, '2-3-2');
INSERT INTO `room` VALUES (87, 40, 360, 4, '2-4-1');
INSERT INTO `room` VALUES (88, 40, 360, 4, '2-4-2');
INSERT INTO `room` VALUES (89, 41, 360, 4, '2-5-1');
INSERT INTO `room` VALUES (90, 41, 360, 4, '2-5-2');
INSERT INTO `room` VALUES (91, 42, 360, 4, '2-6-1');
INSERT INTO `room` VALUES (92, 42, 360, 4, '2-6-2');
INSERT INTO `room` VALUES (93, 43, 360, 4, '2-7-1');
INSERT INTO `room` VALUES (94, 43, 360, 4, '2-7-2');
INSERT INTO `room` VALUES (95, 44, 360, 4, '2-8-1');
INSERT INTO `room` VALUES (96, 44, 360, 4, '2-8-2');
INSERT INTO `room` VALUES (97, 45, 360, 4, '2-9-1');
INSERT INTO `room` VALUES (98, 45, 360, 4, '2-9-2');
INSERT INTO `room` VALUES (99, 46, 360, 4, '2-10-1');
INSERT INTO `room` VALUES (100, 46, 360, 4, '2-10-2');
INSERT INTO `room` VALUES (101, 47, 360, 4, '2-11-1');
INSERT INTO `room` VALUES (102, 47, 360, 4, '2-11-2');
INSERT INTO `room` VALUES (103, 48, 360, 4, '2-12-1');
INSERT INTO `room` VALUES (104, 48, 360, 4, '2-12-2');
INSERT INTO `room` VALUES (105, 49, 360, 4, '2-13-1');
INSERT INTO `room` VALUES (106, 49, 360, 4, '2-13-2');
INSERT INTO `room` VALUES (107, 50, 360, 4, '2-14-1');
INSERT INTO `room` VALUES (108, 50, 360, 4, '2-14-2');
INSERT INTO `room` VALUES (109, 51, 360, 4, '2-15-1');
INSERT INTO `room` VALUES (110, 51, 360, 4, '2-15-2');
INSERT INTO `room` VALUES (111, 52, 360, 4, '2-16-1');
INSERT INTO `room` VALUES (112, 52, 360, 4, '2-16-2');
INSERT INTO `room` VALUES (113, 53, 360, 4, '2-17-1');
INSERT INTO `room` VALUES (114, 53, 360, 4, '2-17-2');
INSERT INTO `room` VALUES (115, 54, 360, 4, '2-18-1');
INSERT INTO `room` VALUES (116, 54, 360, 4, '2-18-2');
INSERT INTO `room` VALUES (117, 55, 360, 4, '2-19-1');
INSERT INTO `room` VALUES (118, 55, 360, 4, '2-19-2');
INSERT INTO `room` VALUES (119, 56, 360, 4, '2-20-1');
INSERT INTO `room` VALUES (120, 56, 360, 4, '2-20-2');
INSERT INTO `room` VALUES (121, 57, 360, 4, '2-21-1');
INSERT INTO `room` VALUES (122, 57, 360, 4, '2-21-2');
INSERT INTO `room` VALUES (123, 58, 360, 4, '2-22-1');
INSERT INTO `room` VALUES (124, 58, 360, 4, '2-22-2');
INSERT INTO `room` VALUES (125, 59, 360, 4, '2-23-1');
INSERT INTO `room` VALUES (126, 59, 360, 4, '2-23-2');
INSERT INTO `room` VALUES (127, 60, 360, 4, '2-24-1');
INSERT INTO `room` VALUES (128, 60, 360, 4, '2-24-2');
INSERT INTO `room` VALUES (129, 61, 360, 4, '2-25-1');
INSERT INTO `room` VALUES (130, 61, 360, 4, '2-25-2');
INSERT INTO `room` VALUES (131, 62, 360, 4, '2-26-1');
INSERT INTO `room` VALUES (132, 62, 360, 4, '2-26-2');
INSERT INTO `room` VALUES (133, 63, 360, 4, '2-27-1');
INSERT INTO `room` VALUES (134, 63, 360, 4, '2-27-2');
INSERT INTO `room` VALUES (135, 64, 360, 4, '2-28-1');
INSERT INTO `room` VALUES (136, 64, 360, 4, '2-28-2');
INSERT INTO `room` VALUES (137, 65, 360, 4, '3-1-1');
INSERT INTO `room` VALUES (138, 65, 360, 4, '3-1-2');
INSERT INTO `room` VALUES (139, 66, 360, 4, '3-2-1');
INSERT INTO `room` VALUES (140, 66, 360, 4, '3-2-2');
INSERT INTO `room` VALUES (141, 67, 360, 4, '3-3-1');
INSERT INTO `room` VALUES (142, 67, 360, 4, '3-3-2');
INSERT INTO `room` VALUES (143, 68, 360, 4, '3-4-1');
INSERT INTO `room` VALUES (144, 68, 360, 4, '3-4-2');
INSERT INTO `room` VALUES (145, 69, 360, 4, '3-5-1');
INSERT INTO `room` VALUES (146, 69, 360, 4, '3-5-2');
INSERT INTO `room` VALUES (147, 70, 360, 4, '3-6-1');
INSERT INTO `room` VALUES (148, 70, 360, 4, '3-6-2');
INSERT INTO `room` VALUES (149, 71, 360, 4, '3-7-1');
INSERT INTO `room` VALUES (150, 71, 360, 4, '3-7-2');
INSERT INTO `room` VALUES (151, 72, 360, 4, '3-8-1');
INSERT INTO `room` VALUES (152, 72, 360, 4, '3-8-2');
INSERT INTO `room` VALUES (153, 73, 360, 4, '3-9-1');
INSERT INTO `room` VALUES (154, 73, 360, 4, '3-9-2');
INSERT INTO `room` VALUES (155, 74, 360, 4, '3-10-1');
INSERT INTO `room` VALUES (156, 74, 360, 4, '3-10-2');
INSERT INTO `room` VALUES (157, 75, 360, 4, '3-11-1');
INSERT INTO `room` VALUES (158, 75, 360, 4, '3-11-2');
INSERT INTO `room` VALUES (159, 76, 360, 4, '3-12-1');
INSERT INTO `room` VALUES (160, 76, 360, 4, '3-12-2');
INSERT INTO `room` VALUES (161, 77, 360, 4, '3-13-1');
INSERT INTO `room` VALUES (162, 77, 360, 4, '3-13-2');
INSERT INTO `room` VALUES (163, 78, 360, 4, '3-14-1');
INSERT INTO `room` VALUES (164, 78, 360, 4, '3-14-2');
INSERT INTO `room` VALUES (165, 79, 360, 4, '3-15-1');
INSERT INTO `room` VALUES (166, 79, 360, 4, '3-15-2');
INSERT INTO `room` VALUES (167, 80, 360, 4, '3-16-1');
INSERT INTO `room` VALUES (168, 80, 360, 4, '3-16-2');
INSERT INTO `room` VALUES (169, 81, 360, 4, '3-17-1');
INSERT INTO `room` VALUES (170, 81, 360, 4, '3-17-2');
INSERT INTO `room` VALUES (171, 82, 360, 4, '3-18-1');
INSERT INTO `room` VALUES (172, 82, 360, 4, '3-18-2');
INSERT INTO `room` VALUES (173, 83, 360, 4, '3-19-1');
INSERT INTO `room` VALUES (174, 83, 360, 4, '3-19-2');
INSERT INTO `room` VALUES (175, 84, 360, 4, '3-20-1');
INSERT INTO `room` VALUES (176, 84, 360, 4, '3-20-2');
INSERT INTO `room` VALUES (177, 85, 360, 4, '3-21-1');
INSERT INTO `room` VALUES (178, 85, 360, 4, '3-21-2');
INSERT INTO `room` VALUES (179, 86, 360, 4, '3-22-1');
INSERT INTO `room` VALUES (180, 86, 360, 4, '3-22-2');
INSERT INTO `room` VALUES (181, 87, 360, 4, '3-23-1');
INSERT INTO `room` VALUES (182, 87, 360, 4, '3-23-2');
INSERT INTO `room` VALUES (183, 88, 360, 4, '3-24-1');
INSERT INTO `room` VALUES (184, 88, 360, 4, '3-24-2');
INSERT INTO `room` VALUES (185, 89, 360, 4, '3-25-1');
INSERT INTO `room` VALUES (186, 89, 360, 4, '3-25-2');
INSERT INTO `room` VALUES (187, 90, 360, 4, '3-26-1');
INSERT INTO `room` VALUES (188, 90, 360, 4, '3-26-2');
INSERT INTO `room` VALUES (189, 91, 360, 4, '3-27-1');
INSERT INTO `room` VALUES (190, 91, 360, 4, '3-27-2');
INSERT INTO `room` VALUES (191, 92, 360, 4, '3-28-1');
INSERT INTO `room` VALUES (192, 92, 360, 4, '3-28-2');
INSERT INTO `room` VALUES (193, 93, 360, 4, '4-1-1');
INSERT INTO `room` VALUES (194, 93, 360, 4, '4-1-2');
INSERT INTO `room` VALUES (195, 94, 360, 4, '4-2-1');
INSERT INTO `room` VALUES (196, 94, 360, 4, '4-2-2');
INSERT INTO `room` VALUES (197, 95, 360, 4, '4-3-1');
INSERT INTO `room` VALUES (198, 95, 360, 4, '4-3-2');
INSERT INTO `room` VALUES (199, 96, 360, 4, '4-4-1');
INSERT INTO `room` VALUES (200, 96, 360, 4, '4-4-2');
INSERT INTO `room` VALUES (201, 97, 360, 4, '4-5-1');
INSERT INTO `room` VALUES (202, 97, 360, 4, '4-5-2');
INSERT INTO `room` VALUES (203, 98, 360, 4, '4-6-1');
INSERT INTO `room` VALUES (204, 98, 360, 4, '4-6-2');
INSERT INTO `room` VALUES (205, 99, 360, 4, '4-7-1');
INSERT INTO `room` VALUES (206, 99, 360, 4, '4-7-2');
INSERT INTO `room` VALUES (207, 100, 360, 4, '4-8-1');
INSERT INTO `room` VALUES (208, 100, 360, 4, '4-8-2');
INSERT INTO `room` VALUES (209, 101, 360, 4, '4-9-1');
INSERT INTO `room` VALUES (210, 101, 360, 4, '4-9-2');
INSERT INTO `room` VALUES (211, 102, 360, 4, '4-10-1');
INSERT INTO `room` VALUES (212, 102, 360, 4, '4-10-2');
INSERT INTO `room` VALUES (213, 103, 360, 4, '4-11-1');
INSERT INTO `room` VALUES (214, 103, 360, 4, '4-11-2');
INSERT INTO `room` VALUES (215, 104, 360, 4, '4-12-1');
INSERT INTO `room` VALUES (216, 104, 360, 4, '4-12-2');
INSERT INTO `room` VALUES (217, 105, 360, 4, '4-13-1');
INSERT INTO `room` VALUES (218, 105, 360, 4, '4-13-2');
INSERT INTO `room` VALUES (219, 106, 360, 4, '4-14-1');
INSERT INTO `room` VALUES (220, 106, 360, 4, '4-14-2');
INSERT INTO `room` VALUES (221, 107, 360, 4, '4-15-1');
INSERT INTO `room` VALUES (222, 107, 360, 4, '4-15-2');
INSERT INTO `room` VALUES (223, 108, 360, 4, '4-16-1');
INSERT INTO `room` VALUES (224, 108, 360, 4, '4-16-2');
INSERT INTO `room` VALUES (225, 109, 360, 4, '4-17-1');
INSERT INTO `room` VALUES (226, 109, 360, 4, '4-17-2');
INSERT INTO `room` VALUES (227, 110, 360, 4, '4-18-1');
INSERT INTO `room` VALUES (228, 110, 360, 4, '4-18-2');
INSERT INTO `room` VALUES (229, 111, 360, 4, '4-19-1');
INSERT INTO `room` VALUES (230, 111, 360, 4, '4-19-2');
INSERT INTO `room` VALUES (231, 112, 360, 4, '4-20-1');
INSERT INTO `room` VALUES (232, 112, 360, 4, '4-20-2');
INSERT INTO `room` VALUES (233, 113, 360, 4, '4-21-1');
INSERT INTO `room` VALUES (234, 113, 360, 4, '4-21-2');
INSERT INTO `room` VALUES (235, 114, 360, 4, '4-22-1');
INSERT INTO `room` VALUES (236, 114, 360, 4, '4-22-2');
INSERT INTO `room` VALUES (237, 115, 360, 4, '4-23-1');
INSERT INTO `room` VALUES (238, 115, 360, 4, '4-23-2');
INSERT INTO `room` VALUES (239, 116, 360, 4, '4-24-1');
INSERT INTO `room` VALUES (240, 116, 360, 4, '4-24-2');
INSERT INTO `room` VALUES (241, 117, 360, 4, '4-25-1');
INSERT INTO `room` VALUES (242, 117, 360, 4, '4-25-2');
INSERT INTO `room` VALUES (243, 118, 360, 4, '4-26-1');
INSERT INTO `room` VALUES (244, 118, 360, 4, '4-26-2');
INSERT INTO `room` VALUES (245, 119, 360, 4, '4-27-1');
INSERT INTO `room` VALUES (246, 119, 360, 4, '4-27-2');
INSERT INTO `room` VALUES (247, 120, 360, 4, '4-28-1');
INSERT INTO `room` VALUES (248, 120, 360, 4, '4-28-2');
INSERT INTO `room` VALUES (249, 121, 360, 4, '5-1-1');
INSERT INTO `room` VALUES (250, 121, 360, 4, '5-1-2');
INSERT INTO `room` VALUES (251, 122, 360, 4, '5-2-1');
INSERT INTO `room` VALUES (252, 122, 360, 4, '5-2-2');
INSERT INTO `room` VALUES (253, 123, 360, 4, '5-3-1');
INSERT INTO `room` VALUES (254, 123, 360, 4, '5-3-2');
INSERT INTO `room` VALUES (255, 124, 360, 4, '5-4-1');
INSERT INTO `room` VALUES (256, 124, 360, 4, '5-4-2');
INSERT INTO `room` VALUES (257, 125, 360, 4, '5-5-1');
INSERT INTO `room` VALUES (258, 125, 360, 4, '5-5-2');
INSERT INTO `room` VALUES (259, 126, 360, 4, '5-6-1');
INSERT INTO `room` VALUES (260, 126, 360, 4, '5-6-2');
INSERT INTO `room` VALUES (261, 127, 360, 4, '5-7-1');
INSERT INTO `room` VALUES (262, 127, 360, 4, '5-7-2');
INSERT INTO `room` VALUES (263, 128, 360, 4, '5-8-1');
INSERT INTO `room` VALUES (264, 128, 360, 4, '5-8-2');
INSERT INTO `room` VALUES (265, 129, 360, 4, '5-9-1');
INSERT INTO `room` VALUES (266, 129, 360, 4, '5-9-2');
INSERT INTO `room` VALUES (267, 130, 360, 4, '5-10-1');
INSERT INTO `room` VALUES (268, 130, 360, 4, '5-10-2');
INSERT INTO `room` VALUES (269, 131, 360, 4, '5-11-1');
INSERT INTO `room` VALUES (270, 131, 360, 4, '5-11-2');
INSERT INTO `room` VALUES (271, 132, 360, 4, '5-12-1');
INSERT INTO `room` VALUES (272, 132, 360, 4, '5-12-2');
INSERT INTO `room` VALUES (273, 133, 360, 4, '5-13-1');
INSERT INTO `room` VALUES (274, 133, 360, 4, '5-13-2');
INSERT INTO `room` VALUES (275, 134, 360, 4, '5-14-1');
INSERT INTO `room` VALUES (276, 134, 360, 4, '5-14-2');
INSERT INTO `room` VALUES (277, 135, 360, 4, '5-15-1');
INSERT INTO `room` VALUES (278, 135, 360, 4, '5-15-2');
INSERT INTO `room` VALUES (279, 136, 360, 4, '5-16-1');
INSERT INTO `room` VALUES (280, 136, 360, 4, '5-16-2');
INSERT INTO `room` VALUES (281, 137, 360, 4, '5-17-1');
INSERT INTO `room` VALUES (282, 137, 360, 4, '5-17-2');
INSERT INTO `room` VALUES (283, 138, 360, 4, '5-18-1');
INSERT INTO `room` VALUES (284, 138, 360, 4, '5-18-2');
INSERT INTO `room` VALUES (285, 139, 360, 4, '5-19-1');
INSERT INTO `room` VALUES (286, 139, 360, 4, '5-19-2');
INSERT INTO `room` VALUES (287, 140, 360, 4, '5-20-1');
INSERT INTO `room` VALUES (288, 140, 360, 4, '5-20-2');
INSERT INTO `room` VALUES (289, 141, 360, 4, '5-21-1');
INSERT INTO `room` VALUES (290, 141, 360, 4, '5-21-2');
INSERT INTO `room` VALUES (291, 142, 360, 4, '5-22-1');
INSERT INTO `room` VALUES (292, 142, 360, 4, '5-22-2');
INSERT INTO `room` VALUES (293, 143, 360, 4, '5-23-1');
INSERT INTO `room` VALUES (294, 143, 360, 4, '5-23-2');
INSERT INTO `room` VALUES (295, 144, 360, 4, '5-24-1');
INSERT INTO `room` VALUES (296, 144, 360, 4, '5-24-2');
INSERT INTO `room` VALUES (297, 145, 360, 4, '5-25-1');
INSERT INTO `room` VALUES (298, 145, 360, 4, '5-25-2');
INSERT INTO `room` VALUES (299, 146, 360, 4, '5-26-1');
INSERT INTO `room` VALUES (300, 146, 360, 4, '5-26-2');
INSERT INTO `room` VALUES (301, 147, 360, 4, '5-27-1');
INSERT INTO `room` VALUES (302, 147, 360, 4, '5-27-2');
INSERT INTO `room` VALUES (303, 148, 360, 4, '5-28-1');
INSERT INTO `room` VALUES (304, 148, 360, 4, '5-28-2');
INSERT INTO `room` VALUES (305, 149, 360, 4, '6-1-1');
INSERT INTO `room` VALUES (306, 149, 360, 4, '6-1-2');
INSERT INTO `room` VALUES (307, 150, 360, 4, '6-2-1');
INSERT INTO `room` VALUES (308, 150, 360, 4, '6-2-2');
INSERT INTO `room` VALUES (309, 151, 360, 4, '6-3-1');
INSERT INTO `room` VALUES (310, 151, 360, 4, '6-3-2');
INSERT INTO `room` VALUES (311, 152, 360, 4, '6-4-1');
INSERT INTO `room` VALUES (312, 152, 360, 4, '6-4-2');
INSERT INTO `room` VALUES (313, 153, 360, 4, '6-5-1');
INSERT INTO `room` VALUES (314, 153, 360, 4, '6-5-2');
INSERT INTO `room` VALUES (315, 154, 360, 4, '6-6-1');
INSERT INTO `room` VALUES (316, 154, 360, 4, '6-6-2');
INSERT INTO `room` VALUES (317, 155, 360, 4, '6-7-1');
INSERT INTO `room` VALUES (318, 155, 360, 4, '6-7-2');
INSERT INTO `room` VALUES (319, 156, 360, 4, '6-8-1');
INSERT INTO `room` VALUES (320, 156, 360, 4, '6-8-2');
INSERT INTO `room` VALUES (321, 157, 360, 4, '6-9-1');
INSERT INTO `room` VALUES (322, 157, 360, 4, '6-9-2');
INSERT INTO `room` VALUES (323, 158, 360, 4, '6-10-1');
INSERT INTO `room` VALUES (324, 158, 360, 4, '6-10-2');
INSERT INTO `room` VALUES (325, 159, 360, 4, '6-11-1');
INSERT INTO `room` VALUES (326, 159, 360, 4, '6-11-2');
INSERT INTO `room` VALUES (327, 160, 360, 4, '6-12-1');
INSERT INTO `room` VALUES (328, 160, 360, 4, '6-12-2');
INSERT INTO `room` VALUES (329, 161, 360, 4, '6-13-1');
INSERT INTO `room` VALUES (330, 161, 360, 4, '6-13-2');
INSERT INTO `room` VALUES (331, 162, 360, 4, '6-14-1');
INSERT INTO `room` VALUES (332, 162, 360, 4, '6-14-2');
INSERT INTO `room` VALUES (333, 163, 360, 4, '6-15-1');
INSERT INTO `room` VALUES (334, 163, 360, 4, '6-15-2');
INSERT INTO `room` VALUES (335, 164, 360, 4, '6-16-1');
INSERT INTO `room` VALUES (336, 164, 360, 4, '6-16-2');
INSERT INTO `room` VALUES (337, 165, 360, 4, '6-17-1');
INSERT INTO `room` VALUES (338, 165, 360, 4, '6-17-2');
INSERT INTO `room` VALUES (339, 166, 360, 4, '6-18-1');
INSERT INTO `room` VALUES (340, 166, 360, 4, '6-18-2');
INSERT INTO `room` VALUES (341, 167, 360, 4, '6-19-1');
INSERT INTO `room` VALUES (342, 167, 360, 4, '6-19-2');
INSERT INTO `room` VALUES (343, 168, 360, 4, '6-20-1');
INSERT INTO `room` VALUES (344, 168, 360, 4, '6-20-2');
INSERT INTO `room` VALUES (345, 169, 360, 4, '6-21-1');
INSERT INTO `room` VALUES (346, 169, 360, 4, '6-21-2');
INSERT INTO `room` VALUES (347, 170, 360, 4, '6-22-1');
INSERT INTO `room` VALUES (348, 170, 360, 4, '6-22-2');
INSERT INTO `room` VALUES (349, 171, 360, 4, '6-23-1');
INSERT INTO `room` VALUES (350, 171, 360, 4, '6-23-2');
INSERT INTO `room` VALUES (351, 172, 360, 4, '6-24-1');
INSERT INTO `room` VALUES (352, 172, 360, 4, '6-24-2');
INSERT INTO `room` VALUES (353, 173, 360, 4, '6-25-1');
INSERT INTO `room` VALUES (354, 173, 360, 4, '6-25-2');
INSERT INTO `room` VALUES (355, 174, 360, 4, '6-26-1');
INSERT INTO `room` VALUES (356, 174, 360, 4, '6-26-2');
INSERT INTO `room` VALUES (357, 175, 360, 4, '6-27-1');
INSERT INTO `room` VALUES (358, 175, 360, 4, '6-27-2');
INSERT INTO `room` VALUES (359, 176, 360, 4, '6-28-1');
INSERT INTO `room` VALUES (360, 176, 360, 4, '6-28-2');
INSERT INTO `room` VALUES (361, 177, 360, 4, '2-1-1');
INSERT INTO `room` VALUES (362, 177, 360, 4, '2-1-2');
INSERT INTO `room` VALUES (363, 178, 360, 4, '2-2-1');
INSERT INTO `room` VALUES (364, 178, 360, 4, '2-2-2');
INSERT INTO `room` VALUES (365, 179, 360, 4, '2-3-1');
INSERT INTO `room` VALUES (366, 179, 360, 4, '2-3-2');
INSERT INTO `room` VALUES (367, 180, 360, 4, '2-4-1');
INSERT INTO `room` VALUES (368, 180, 360, 4, '2-4-2');
INSERT INTO `room` VALUES (369, 181, 360, 4, '2-5-1');
INSERT INTO `room` VALUES (370, 181, 360, 4, '2-5-2');
INSERT INTO `room` VALUES (371, 182, 360, 4, '2-6-1');
INSERT INTO `room` VALUES (372, 182, 360, 4, '2-6-2');
INSERT INTO `room` VALUES (373, 183, 360, 4, '2-7-1');
INSERT INTO `room` VALUES (374, 183, 360, 4, '2-7-2');
INSERT INTO `room` VALUES (375, 184, 360, 4, '2-8-1');
INSERT INTO `room` VALUES (376, 184, 360, 4, '2-8-2');
INSERT INTO `room` VALUES (377, 185, 360, 4, '2-9-1');
INSERT INTO `room` VALUES (378, 185, 360, 4, '2-9-2');
INSERT INTO `room` VALUES (379, 186, 360, 4, '2-10-1');
INSERT INTO `room` VALUES (380, 186, 360, 4, '2-10-2');
INSERT INTO `room` VALUES (381, 187, 360, 4, '2-11-1');
INSERT INTO `room` VALUES (382, 187, 360, 4, '2-11-2');
INSERT INTO `room` VALUES (383, 188, 360, 4, '2-12-1');
INSERT INTO `room` VALUES (384, 188, 360, 4, '2-12-2');
INSERT INTO `room` VALUES (385, 189, 360, 4, '2-13-1');
INSERT INTO `room` VALUES (386, 189, 360, 4, '2-13-2');
INSERT INTO `room` VALUES (387, 190, 360, 4, '2-14-1');
INSERT INTO `room` VALUES (388, 190, 360, 4, '2-14-2');
INSERT INTO `room` VALUES (389, 191, 360, 4, '2-15-1');
INSERT INTO `room` VALUES (390, 191, 360, 4, '2-15-2');
INSERT INTO `room` VALUES (391, 192, 360, 4, '2-16-1');
INSERT INTO `room` VALUES (392, 192, 360, 4, '2-16-2');
INSERT INTO `room` VALUES (393, 193, 360, 4, '2-17-1');
INSERT INTO `room` VALUES (394, 193, 360, 4, '2-17-2');
INSERT INTO `room` VALUES (395, 194, 360, 4, '2-18-1');
INSERT INTO `room` VALUES (396, 194, 360, 4, '2-18-2');
INSERT INTO `room` VALUES (397, 195, 360, 4, '2-19-1');
INSERT INTO `room` VALUES (398, 195, 360, 4, '2-19-2');
INSERT INTO `room` VALUES (399, 196, 360, 4, '2-20-1');
INSERT INTO `room` VALUES (400, 196, 360, 4, '2-20-2');
INSERT INTO `room` VALUES (401, 197, 360, 4, '2-21-1');
INSERT INTO `room` VALUES (402, 197, 360, 4, '2-21-2');
INSERT INTO `room` VALUES (403, 198, 360, 4, '2-22-1');
INSERT INTO `room` VALUES (404, 198, 360, 4, '2-22-2');
INSERT INTO `room` VALUES (405, 199, 360, 4, '2-23-1');
INSERT INTO `room` VALUES (406, 199, 360, 4, '2-23-2');
INSERT INTO `room` VALUES (407, 200, 360, 4, '2-24-1');
INSERT INTO `room` VALUES (408, 200, 360, 4, '2-24-2');
INSERT INTO `room` VALUES (409, 201, 360, 4, '2-25-1');
INSERT INTO `room` VALUES (410, 201, 360, 4, '2-25-2');
INSERT INTO `room` VALUES (411, 202, 360, 4, '2-26-1');
INSERT INTO `room` VALUES (412, 202, 360, 4, '2-26-2');
INSERT INTO `room` VALUES (413, 203, 360, 4, '2-27-1');
INSERT INTO `room` VALUES (414, 203, 360, 4, '2-27-2');
INSERT INTO `room` VALUES (415, 204, 360, 4, '2-28-1');
INSERT INTO `room` VALUES (416, 204, 360, 4, '2-28-2');
INSERT INTO `room` VALUES (417, 205, 360, 4, '2-29-1');
INSERT INTO `room` VALUES (418, 205, 360, 4, '2-29-2');
INSERT INTO `room` VALUES (419, 206, 360, 4, '2-30-1');
INSERT INTO `room` VALUES (420, 206, 360, 4, '2-30-2');
INSERT INTO `room` VALUES (421, 207, 360, 4, '2-31-1');
INSERT INTO `room` VALUES (422, 207, 360, 4, '2-31-2');
INSERT INTO `room` VALUES (423, 208, 360, 4, '2-32-1');
INSERT INTO `room` VALUES (424, 208, 360, 4, '2-32-2');
INSERT INTO `room` VALUES (425, 209, 360, 4, '2-33-1');
INSERT INTO `room` VALUES (426, 209, 360, 4, '2-33-2');
INSERT INTO `room` VALUES (427, 210, 360, 4, '2-34-1');
INSERT INTO `room` VALUES (428, 210, 360, 4, '2-34-2');
INSERT INTO `room` VALUES (429, 211, 360, 4, '2-35-1');
INSERT INTO `room` VALUES (430, 211, 360, 4, '2-35-2');
INSERT INTO `room` VALUES (431, 212, 360, 4, '2-36-1');
INSERT INTO `room` VALUES (432, 212, 360, 4, '2-36-2');
INSERT INTO `room` VALUES (433, 213, 360, 4, '2-37-1');
INSERT INTO `room` VALUES (434, 213, 360, 4, '2-37-2');
INSERT INTO `room` VALUES (435, 214, 360, 4, '2-38-1');
INSERT INTO `room` VALUES (436, 214, 360, 4, '2-38-2');
INSERT INTO `room` VALUES (437, 215, 360, 4, '3-1-1');
INSERT INTO `room` VALUES (438, 215, 360, 4, '3-1-2');
INSERT INTO `room` VALUES (439, 216, 360, 4, '3-2-1');
INSERT INTO `room` VALUES (440, 216, 360, 4, '3-2-2');
INSERT INTO `room` VALUES (441, 217, 360, 4, '3-3-1');
INSERT INTO `room` VALUES (442, 217, 360, 4, '3-3-2');
INSERT INTO `room` VALUES (443, 218, 360, 4, '3-4-1');
INSERT INTO `room` VALUES (444, 218, 360, 4, '3-4-2');
INSERT INTO `room` VALUES (445, 219, 360, 4, '3-5-1');
INSERT INTO `room` VALUES (446, 219, 360, 4, '3-5-2');
INSERT INTO `room` VALUES (447, 220, 360, 4, '3-6-1');
INSERT INTO `room` VALUES (448, 220, 360, 4, '3-6-2');
INSERT INTO `room` VALUES (449, 221, 360, 4, '3-7-1');
INSERT INTO `room` VALUES (450, 221, 360, 4, '3-7-2');
INSERT INTO `room` VALUES (451, 222, 360, 4, '3-8-1');
INSERT INTO `room` VALUES (452, 222, 360, 4, '3-8-2');
INSERT INTO `room` VALUES (453, 223, 360, 4, '3-9-1');
INSERT INTO `room` VALUES (454, 223, 360, 4, '3-9-2');
INSERT INTO `room` VALUES (455, 224, 360, 4, '3-10-1');
INSERT INTO `room` VALUES (456, 224, 360, 4, '3-10-2');
INSERT INTO `room` VALUES (457, 225, 360, 4, '3-11-1');
INSERT INTO `room` VALUES (458, 225, 360, 4, '3-11-2');
INSERT INTO `room` VALUES (459, 226, 360, 4, '3-12-1');
INSERT INTO `room` VALUES (460, 226, 360, 4, '3-12-2');
INSERT INTO `room` VALUES (461, 227, 360, 4, '3-13-1');
INSERT INTO `room` VALUES (462, 227, 360, 4, '3-13-2');
INSERT INTO `room` VALUES (463, 228, 360, 4, '3-14-1');
INSERT INTO `room` VALUES (464, 228, 360, 4, '3-14-2');
INSERT INTO `room` VALUES (465, 229, 360, 4, '3-15-1');
INSERT INTO `room` VALUES (466, 229, 360, 4, '3-15-2');
INSERT INTO `room` VALUES (467, 230, 360, 4, '3-16-1');
INSERT INTO `room` VALUES (468, 230, 360, 4, '3-16-2');
INSERT INTO `room` VALUES (469, 231, 360, 4, '3-17-1');
INSERT INTO `room` VALUES (470, 231, 360, 4, '3-17-2');
INSERT INTO `room` VALUES (471, 232, 360, 4, '3-18-1');
INSERT INTO `room` VALUES (472, 232, 360, 4, '3-18-2');
INSERT INTO `room` VALUES (473, 233, 360, 4, '3-19-1');
INSERT INTO `room` VALUES (474, 233, 360, 4, '3-19-2');
INSERT INTO `room` VALUES (475, 234, 360, 4, '3-20-1');
INSERT INTO `room` VALUES (476, 234, 360, 4, '3-20-2');
INSERT INTO `room` VALUES (477, 235, 360, 4, '3-21-1');
INSERT INTO `room` VALUES (478, 235, 360, 4, '3-21-2');
INSERT INTO `room` VALUES (479, 236, 360, 4, '3-22-1');
INSERT INTO `room` VALUES (480, 236, 360, 4, '3-22-2');
INSERT INTO `room` VALUES (481, 237, 360, 4, '3-23-1');
INSERT INTO `room` VALUES (482, 237, 360, 4, '3-23-2');
INSERT INTO `room` VALUES (483, 238, 360, 4, '3-24-1');
INSERT INTO `room` VALUES (484, 238, 360, 4, '3-24-2');
INSERT INTO `room` VALUES (485, 239, 360, 4, '3-25-1');
INSERT INTO `room` VALUES (486, 239, 360, 4, '3-25-2');
INSERT INTO `room` VALUES (487, 240, 360, 4, '3-26-1');
INSERT INTO `room` VALUES (488, 240, 360, 4, '3-26-2');
INSERT INTO `room` VALUES (489, 241, 360, 4, '3-27-1');
INSERT INTO `room` VALUES (490, 241, 360, 4, '3-27-2');
INSERT INTO `room` VALUES (491, 242, 360, 4, '3-28-1');
INSERT INTO `room` VALUES (492, 242, 360, 4, '3-28-2');
INSERT INTO `room` VALUES (493, 243, 360, 4, '3-29-1');
INSERT INTO `room` VALUES (494, 243, 360, 4, '3-29-2');
INSERT INTO `room` VALUES (495, 244, 360, 4, '3-30-1');
INSERT INTO `room` VALUES (496, 244, 360, 4, '3-30-2');
INSERT INTO `room` VALUES (497, 245, 360, 4, '3-31-1');
INSERT INTO `room` VALUES (498, 245, 360, 4, '3-31-2');
INSERT INTO `room` VALUES (499, 246, 360, 4, '3-32-1');
INSERT INTO `room` VALUES (500, 246, 360, 4, '3-32-2');
INSERT INTO `room` VALUES (501, 247, 360, 4, '3-33-1');
INSERT INTO `room` VALUES (502, 247, 360, 4, '3-33-2');
INSERT INTO `room` VALUES (503, 248, 360, 4, '3-34-1');
INSERT INTO `room` VALUES (504, 248, 360, 4, '3-34-2');
INSERT INTO `room` VALUES (505, 249, 360, 4, '3-35-1');
INSERT INTO `room` VALUES (506, 249, 360, 4, '3-35-2');
INSERT INTO `room` VALUES (507, 250, 360, 4, '3-36-1');
INSERT INTO `room` VALUES (508, 250, 360, 4, '3-36-2');
INSERT INTO `room` VALUES (509, 251, 360, 4, '3-37-1');
INSERT INTO `room` VALUES (510, 251, 360, 4, '3-37-2');
INSERT INTO `room` VALUES (511, 252, 360, 4, '3-38-1');
INSERT INTO `room` VALUES (512, 252, 360, 4, '3-38-2');
INSERT INTO `room` VALUES (513, 253, 360, 4, '4-1-1');
INSERT INTO `room` VALUES (514, 253, 360, 4, '4-1-2');
INSERT INTO `room` VALUES (515, 254, 360, 4, '4-2-1');
INSERT INTO `room` VALUES (516, 254, 360, 4, '4-2-2');
INSERT INTO `room` VALUES (517, 255, 360, 4, '4-3-1');
INSERT INTO `room` VALUES (518, 255, 360, 4, '4-3-2');
INSERT INTO `room` VALUES (519, 256, 360, 4, '4-4-1');
INSERT INTO `room` VALUES (520, 256, 360, 4, '4-4-2');
INSERT INTO `room` VALUES (521, 257, 360, 4, '4-5-1');
INSERT INTO `room` VALUES (522, 257, 360, 4, '4-5-2');
INSERT INTO `room` VALUES (523, 258, 360, 4, '4-6-1');
INSERT INTO `room` VALUES (524, 258, 360, 4, '4-6-2');
INSERT INTO `room` VALUES (525, 259, 360, 4, '4-7-1');
INSERT INTO `room` VALUES (526, 259, 360, 4, '4-7-2');
INSERT INTO `room` VALUES (527, 260, 360, 4, '4-8-1');
INSERT INTO `room` VALUES (528, 260, 360, 4, '4-8-2');
INSERT INTO `room` VALUES (529, 261, 360, 4, '4-9-1');
INSERT INTO `room` VALUES (530, 261, 360, 4, '4-9-2');
INSERT INTO `room` VALUES (531, 262, 360, 4, '4-10-1');
INSERT INTO `room` VALUES (532, 262, 360, 4, '4-10-2');
INSERT INTO `room` VALUES (533, 263, 360, 4, '4-11-1');
INSERT INTO `room` VALUES (534, 263, 360, 4, '4-11-2');
INSERT INTO `room` VALUES (535, 264, 360, 4, '4-12-1');
INSERT INTO `room` VALUES (536, 264, 360, 4, '4-12-2');
INSERT INTO `room` VALUES (537, 265, 360, 4, '4-13-1');
INSERT INTO `room` VALUES (538, 265, 360, 4, '4-13-2');
INSERT INTO `room` VALUES (539, 266, 360, 4, '4-14-1');
INSERT INTO `room` VALUES (540, 266, 360, 4, '4-14-2');
INSERT INTO `room` VALUES (541, 267, 360, 4, '4-15-1');
INSERT INTO `room` VALUES (542, 267, 360, 4, '4-15-2');
INSERT INTO `room` VALUES (543, 268, 360, 4, '4-16-1');
INSERT INTO `room` VALUES (544, 268, 360, 4, '4-16-2');
INSERT INTO `room` VALUES (545, 269, 360, 4, '4-17-1');
INSERT INTO `room` VALUES (546, 269, 360, 4, '4-17-2');
INSERT INTO `room` VALUES (547, 270, 360, 4, '4-18-1');
INSERT INTO `room` VALUES (548, 270, 360, 4, '4-18-2');
INSERT INTO `room` VALUES (549, 271, 360, 4, '4-19-1');
INSERT INTO `room` VALUES (550, 271, 360, 4, '4-19-2');
INSERT INTO `room` VALUES (551, 272, 360, 4, '4-20-1');
INSERT INTO `room` VALUES (552, 272, 360, 4, '4-20-2');
INSERT INTO `room` VALUES (553, 273, 360, 4, '4-21-1');
INSERT INTO `room` VALUES (554, 273, 360, 4, '4-21-2');
INSERT INTO `room` VALUES (555, 274, 360, 4, '4-22-1');
INSERT INTO `room` VALUES (556, 274, 360, 4, '4-22-2');
INSERT INTO `room` VALUES (557, 275, 360, 4, '4-23-1');
INSERT INTO `room` VALUES (558, 275, 360, 4, '4-23-2');
INSERT INTO `room` VALUES (559, 276, 360, 4, '4-24-1');
INSERT INTO `room` VALUES (560, 276, 360, 4, '4-24-2');
INSERT INTO `room` VALUES (561, 277, 360, 4, '4-25-1');
INSERT INTO `room` VALUES (562, 277, 360, 4, '4-25-2');
INSERT INTO `room` VALUES (563, 278, 360, 4, '4-26-1');
INSERT INTO `room` VALUES (564, 278, 360, 4, '4-26-2');
INSERT INTO `room` VALUES (565, 279, 360, 4, '4-27-1');
INSERT INTO `room` VALUES (566, 279, 360, 4, '4-27-2');
INSERT INTO `room` VALUES (567, 280, 360, 4, '4-28-1');
INSERT INTO `room` VALUES (568, 280, 360, 4, '4-28-2');
INSERT INTO `room` VALUES (569, 281, 360, 4, '4-29-1');
INSERT INTO `room` VALUES (570, 281, 360, 4, '4-29-2');
INSERT INTO `room` VALUES (571, 282, 360, 4, '4-30-1');
INSERT INTO `room` VALUES (572, 282, 360, 4, '4-30-2');
INSERT INTO `room` VALUES (573, 283, 360, 4, '4-31-1');
INSERT INTO `room` VALUES (574, 283, 360, 4, '4-31-2');
INSERT INTO `room` VALUES (575, 284, 360, 4, '4-32-1');
INSERT INTO `room` VALUES (576, 284, 360, 4, '4-32-2');
INSERT INTO `room` VALUES (577, 285, 360, 4, '4-33-1');
INSERT INTO `room` VALUES (578, 285, 360, 4, '4-33-2');
INSERT INTO `room` VALUES (579, 286, 360, 4, '4-34-1');
INSERT INTO `room` VALUES (580, 286, 360, 4, '4-34-2');
INSERT INTO `room` VALUES (581, 287, 360, 4, '4-35-1');
INSERT INTO `room` VALUES (582, 287, 360, 4, '4-35-2');
INSERT INTO `room` VALUES (583, 288, 360, 4, '4-36-1');
INSERT INTO `room` VALUES (584, 288, 360, 4, '4-36-2');
INSERT INTO `room` VALUES (585, 289, 360, 4, '4-37-1');
INSERT INTO `room` VALUES (586, 289, 360, 4, '4-37-2');
INSERT INTO `room` VALUES (587, 290, 360, 4, '4-38-1');
INSERT INTO `room` VALUES (588, 290, 360, 4, '4-38-2');
INSERT INTO `room` VALUES (589, 291, 360, 4, '5-1-1');
INSERT INTO `room` VALUES (590, 291, 360, 4, '5-1-2');
INSERT INTO `room` VALUES (591, 292, 360, 4, '5-2-1');
INSERT INTO `room` VALUES (592, 292, 360, 4, '5-2-2');
INSERT INTO `room` VALUES (593, 293, 360, 4, '5-3-1');
INSERT INTO `room` VALUES (594, 293, 360, 4, '5-3-2');
INSERT INTO `room` VALUES (595, 294, 360, 4, '5-4-1');
INSERT INTO `room` VALUES (596, 294, 360, 4, '5-4-2');
INSERT INTO `room` VALUES (597, 295, 360, 4, '5-5-1');
INSERT INTO `room` VALUES (598, 295, 360, 4, '5-5-2');
INSERT INTO `room` VALUES (599, 296, 360, 4, '5-6-1');
INSERT INTO `room` VALUES (600, 296, 360, 4, '5-6-2');
INSERT INTO `room` VALUES (601, 297, 360, 4, '5-7-1');
INSERT INTO `room` VALUES (602, 297, 360, 4, '5-7-2');
INSERT INTO `room` VALUES (603, 298, 360, 4, '5-8-1');
INSERT INTO `room` VALUES (604, 298, 360, 4, '5-8-2');
INSERT INTO `room` VALUES (605, 299, 360, 4, '5-9-1');
INSERT INTO `room` VALUES (606, 299, 360, 4, '5-9-2');
INSERT INTO `room` VALUES (607, 300, 360, 4, '5-10-1');
INSERT INTO `room` VALUES (608, 300, 360, 4, '5-10-2');
INSERT INTO `room` VALUES (609, 301, 360, 4, '5-11-1');
INSERT INTO `room` VALUES (610, 301, 360, 4, '5-11-2');
INSERT INTO `room` VALUES (611, 302, 360, 4, '5-12-1');
INSERT INTO `room` VALUES (612, 302, 360, 4, '5-12-2');
INSERT INTO `room` VALUES (613, 303, 360, 4, '5-13-1');
INSERT INTO `room` VALUES (614, 303, 360, 4, '5-13-2');
INSERT INTO `room` VALUES (615, 304, 360, 4, '5-14-1');
INSERT INTO `room` VALUES (616, 304, 360, 4, '5-14-2');
INSERT INTO `room` VALUES (617, 305, 360, 4, '5-15-1');
INSERT INTO `room` VALUES (618, 305, 360, 4, '5-15-2');
INSERT INTO `room` VALUES (619, 306, 360, 4, '5-16-1');
INSERT INTO `room` VALUES (620, 306, 360, 4, '5-16-2');
INSERT INTO `room` VALUES (621, 307, 360, 4, '5-17-1');
INSERT INTO `room` VALUES (622, 307, 360, 4, '5-17-2');
INSERT INTO `room` VALUES (623, 308, 360, 4, '5-18-1');
INSERT INTO `room` VALUES (624, 308, 360, 4, '5-18-2');
INSERT INTO `room` VALUES (625, 309, 360, 4, '5-19-1');
INSERT INTO `room` VALUES (626, 309, 360, 4, '5-19-2');
INSERT INTO `room` VALUES (627, 310, 360, 4, '5-20-1');
INSERT INTO `room` VALUES (628, 310, 360, 4, '5-20-2');
INSERT INTO `room` VALUES (629, 311, 360, 4, '5-21-1');
INSERT INTO `room` VALUES (630, 311, 360, 4, '5-21-2');
INSERT INTO `room` VALUES (631, 312, 360, 4, '5-22-1');
INSERT INTO `room` VALUES (632, 312, 360, 4, '5-22-2');
INSERT INTO `room` VALUES (633, 313, 360, 4, '5-23-1');
INSERT INTO `room` VALUES (634, 313, 360, 4, '5-23-2');
INSERT INTO `room` VALUES (635, 314, 360, 4, '5-24-1');
INSERT INTO `room` VALUES (636, 314, 360, 4, '5-24-2');
INSERT INTO `room` VALUES (637, 315, 360, 4, '5-25-1');
INSERT INTO `room` VALUES (638, 315, 360, 4, '5-25-2');
INSERT INTO `room` VALUES (639, 316, 360, 4, '5-26-1');
INSERT INTO `room` VALUES (640, 316, 360, 4, '5-26-2');
INSERT INTO `room` VALUES (641, 317, 360, 4, '5-27-1');
INSERT INTO `room` VALUES (642, 317, 360, 4, '5-27-2');
INSERT INTO `room` VALUES (643, 318, 360, 4, '5-28-1');
INSERT INTO `room` VALUES (644, 318, 360, 4, '5-28-2');
INSERT INTO `room` VALUES (645, 319, 360, 4, '5-29-1');
INSERT INTO `room` VALUES (646, 319, 360, 4, '5-29-2');
INSERT INTO `room` VALUES (647, 320, 360, 4, '5-30-1');
INSERT INTO `room` VALUES (648, 320, 360, 4, '5-30-2');
INSERT INTO `room` VALUES (649, 321, 360, 4, '5-31-1');
INSERT INTO `room` VALUES (650, 321, 360, 4, '5-31-2');
INSERT INTO `room` VALUES (651, 322, 360, 4, '5-32-1');
INSERT INTO `room` VALUES (652, 322, 360, 4, '5-32-2');
INSERT INTO `room` VALUES (653, 323, 360, 4, '5-33-1');
INSERT INTO `room` VALUES (654, 323, 360, 4, '5-33-2');
INSERT INTO `room` VALUES (655, 324, 360, 4, '5-34-1');
INSERT INTO `room` VALUES (656, 324, 360, 4, '5-34-2');
INSERT INTO `room` VALUES (657, 325, 360, 4, '5-35-1');
INSERT INTO `room` VALUES (658, 325, 360, 4, '5-35-2');
INSERT INTO `room` VALUES (659, 326, 360, 4, '5-36-1');
INSERT INTO `room` VALUES (660, 326, 360, 4, '5-36-2');
INSERT INTO `room` VALUES (661, 327, 360, 4, '5-37-1');
INSERT INTO `room` VALUES (662, 327, 360, 4, '5-37-2');
INSERT INTO `room` VALUES (663, 328, 360, 4, '5-38-1');
INSERT INTO `room` VALUES (664, 328, 360, 4, '5-38-2');
INSERT INTO `room` VALUES (665, 329, 360, 4, '6-1-1');
INSERT INTO `room` VALUES (666, 329, 360, 4, '6-1-2');
INSERT INTO `room` VALUES (667, 330, 360, 4, '6-2-1');
INSERT INTO `room` VALUES (668, 330, 360, 4, '6-2-2');
INSERT INTO `room` VALUES (669, 331, 360, 4, '6-3-1');
INSERT INTO `room` VALUES (670, 331, 360, 4, '6-3-2');
INSERT INTO `room` VALUES (671, 332, 360, 4, '6-4-1');
INSERT INTO `room` VALUES (672, 332, 360, 4, '6-4-2');
INSERT INTO `room` VALUES (673, 333, 360, 4, '6-5-1');
INSERT INTO `room` VALUES (674, 333, 360, 4, '6-5-2');
INSERT INTO `room` VALUES (675, 334, 360, 4, '6-6-1');
INSERT INTO `room` VALUES (676, 334, 360, 4, '6-6-2');
INSERT INTO `room` VALUES (677, 335, 360, 4, '6-7-1');
INSERT INTO `room` VALUES (678, 335, 360, 4, '6-7-2');
INSERT INTO `room` VALUES (679, 336, 360, 4, '6-8-1');
INSERT INTO `room` VALUES (680, 336, 360, 4, '6-8-2');
INSERT INTO `room` VALUES (681, 337, 360, 4, '6-9-1');
INSERT INTO `room` VALUES (682, 337, 360, 4, '6-9-2');
INSERT INTO `room` VALUES (683, 338, 360, 4, '6-10-1');
INSERT INTO `room` VALUES (684, 338, 360, 4, '6-10-2');
INSERT INTO `room` VALUES (685, 339, 360, 4, '6-11-1');
INSERT INTO `room` VALUES (686, 339, 360, 4, '6-11-2');
INSERT INTO `room` VALUES (687, 340, 360, 4, '6-12-1');
INSERT INTO `room` VALUES (688, 340, 360, 4, '6-12-2');
INSERT INTO `room` VALUES (689, 341, 360, 4, '6-13-1');
INSERT INTO `room` VALUES (690, 341, 360, 4, '6-13-2');
INSERT INTO `room` VALUES (691, 342, 360, 4, '6-14-1');
INSERT INTO `room` VALUES (692, 342, 360, 4, '6-14-2');
INSERT INTO `room` VALUES (693, 343, 360, 4, '6-15-1');
INSERT INTO `room` VALUES (694, 343, 360, 4, '6-15-2');
INSERT INTO `room` VALUES (695, 344, 360, 4, '6-16-1');
INSERT INTO `room` VALUES (696, 344, 360, 4, '6-16-2');
INSERT INTO `room` VALUES (697, 345, 360, 4, '6-17-1');
INSERT INTO `room` VALUES (698, 345, 360, 4, '6-17-2');
INSERT INTO `room` VALUES (699, 346, 360, 4, '6-18-1');
INSERT INTO `room` VALUES (700, 346, 360, 4, '6-18-2');
INSERT INTO `room` VALUES (701, 347, 360, 4, '6-19-1');
INSERT INTO `room` VALUES (702, 347, 360, 4, '6-19-2');
INSERT INTO `room` VALUES (703, 348, 360, 4, '6-20-1');
INSERT INTO `room` VALUES (704, 348, 360, 4, '6-20-2');
INSERT INTO `room` VALUES (705, 349, 360, 4, '6-21-1');
INSERT INTO `room` VALUES (706, 349, 360, 4, '6-21-2');
INSERT INTO `room` VALUES (707, 350, 360, 4, '6-22-1');
INSERT INTO `room` VALUES (708, 350, 360, 4, '6-22-2');
INSERT INTO `room` VALUES (709, 351, 360, 4, '6-23-1');
INSERT INTO `room` VALUES (710, 351, 360, 4, '6-23-2');
INSERT INTO `room` VALUES (711, 352, 360, 4, '6-24-1');
INSERT INTO `room` VALUES (712, 352, 360, 4, '6-24-2');
INSERT INTO `room` VALUES (713, 353, 360, 4, '6-25-1');
INSERT INTO `room` VALUES (714, 353, 360, 4, '6-25-2');
INSERT INTO `room` VALUES (715, 354, 360, 4, '6-26-1');
INSERT INTO `room` VALUES (716, 354, 360, 4, '6-26-2');
INSERT INTO `room` VALUES (717, 355, 360, 4, '6-27-1');
INSERT INTO `room` VALUES (718, 355, 360, 4, '6-27-2');
INSERT INTO `room` VALUES (719, 356, 360, 4, '6-28-1');
INSERT INTO `room` VALUES (720, 356, 360, 4, '6-28-2');
INSERT INTO `room` VALUES (721, 357, 360, 4, '6-29-1');
INSERT INTO `room` VALUES (722, 357, 360, 4, '6-29-2');
INSERT INTO `room` VALUES (723, 358, 360, 4, '6-30-1');
INSERT INTO `room` VALUES (724, 358, 360, 4, '6-30-2');
INSERT INTO `room` VALUES (725, 359, 360, 4, '6-31-1');
INSERT INTO `room` VALUES (726, 359, 360, 4, '6-31-2');
INSERT INTO `room` VALUES (727, 360, 360, 4, '6-32-1');
INSERT INTO `room` VALUES (728, 360, 360, 4, '6-32-2');
INSERT INTO `room` VALUES (729, 361, 360, 4, '6-33-1');
INSERT INTO `room` VALUES (730, 361, 360, 4, '6-33-2');
INSERT INTO `room` VALUES (731, 362, 360, 4, '6-34-1');
INSERT INTO `room` VALUES (732, 362, 360, 4, '6-34-2');
INSERT INTO `room` VALUES (733, 363, 360, 4, '6-35-1');
INSERT INTO `room` VALUES (734, 363, 360, 4, '6-35-2');
INSERT INTO `room` VALUES (735, 364, 360, 4, '6-36-1');
INSERT INTO `room` VALUES (736, 364, 360, 4, '6-36-2');
INSERT INTO `room` VALUES (737, 365, 360, 4, '6-37-1');
INSERT INTO `room` VALUES (738, 365, 360, 4, '6-37-2');
INSERT INTO `room` VALUES (739, 366, 360, 4, '6-38-1');
INSERT INTO `room` VALUES (740, 366, 360, 4, '6-38-2');
INSERT INTO `room` VALUES (741, 367, 360, 4, '7-1-1');
INSERT INTO `room` VALUES (742, 367, 360, 4, '7-1-2');
INSERT INTO `room` VALUES (743, 368, 360, 4, '7-2-1');
INSERT INTO `room` VALUES (744, 368, 360, 4, '7-2-2');
INSERT INTO `room` VALUES (745, 369, 360, 4, '7-3-1');
INSERT INTO `room` VALUES (746, 369, 360, 4, '7-3-2');
INSERT INTO `room` VALUES (747, 370, 360, 4, '7-4-1');
INSERT INTO `room` VALUES (748, 370, 360, 4, '7-4-2');
INSERT INTO `room` VALUES (749, 371, 360, 4, '7-5-1');
INSERT INTO `room` VALUES (750, 371, 360, 4, '7-5-2');
INSERT INTO `room` VALUES (751, 372, 360, 4, '7-6-1');
INSERT INTO `room` VALUES (752, 372, 360, 4, '7-6-2');
INSERT INTO `room` VALUES (753, 373, 360, 4, '7-7-1');
INSERT INTO `room` VALUES (754, 373, 360, 4, '7-7-2');
INSERT INTO `room` VALUES (755, 374, 360, 4, '7-8-1');
INSERT INTO `room` VALUES (756, 374, 360, 4, '7-8-2');
INSERT INTO `room` VALUES (757, 375, 360, 4, '7-9-1');
INSERT INTO `room` VALUES (758, 375, 360, 4, '7-9-2');
INSERT INTO `room` VALUES (759, 376, 360, 4, '7-10-1');
INSERT INTO `room` VALUES (760, 376, 360, 4, '7-10-2');
INSERT INTO `room` VALUES (761, 377, 360, 4, '7-11-1');
INSERT INTO `room` VALUES (762, 377, 360, 4, '7-11-2');
INSERT INTO `room` VALUES (763, 378, 360, 4, '7-12-1');
INSERT INTO `room` VALUES (764, 378, 360, 4, '7-12-2');
INSERT INTO `room` VALUES (765, 379, 360, 4, '7-13-1');
INSERT INTO `room` VALUES (766, 379, 360, 4, '7-13-2');
INSERT INTO `room` VALUES (767, 380, 360, 4, '7-14-1');
INSERT INTO `room` VALUES (768, 380, 360, 4, '7-14-2');
INSERT INTO `room` VALUES (769, 381, 360, 4, '7-15-1');
INSERT INTO `room` VALUES (770, 381, 360, 4, '7-15-2');
INSERT INTO `room` VALUES (771, 382, 360, 4, '7-16-1');
INSERT INTO `room` VALUES (772, 382, 360, 4, '7-16-2');
INSERT INTO `room` VALUES (773, 383, 360, 4, '7-17-1');
INSERT INTO `room` VALUES (774, 383, 360, 4, '7-17-2');
INSERT INTO `room` VALUES (775, 384, 360, 4, '7-18-1');
INSERT INTO `room` VALUES (776, 384, 360, 4, '7-18-2');
INSERT INTO `room` VALUES (777, 385, 360, 4, '7-19-1');
INSERT INTO `room` VALUES (778, 385, 360, 4, '7-19-2');
INSERT INTO `room` VALUES (779, 386, 360, 4, '7-20-1');
INSERT INTO `room` VALUES (780, 386, 360, 4, '7-20-2');
INSERT INTO `room` VALUES (781, 387, 360, 4, '7-21-1');
INSERT INTO `room` VALUES (782, 387, 360, 4, '7-21-2');
INSERT INTO `room` VALUES (783, 388, 360, 4, '7-22-1');
INSERT INTO `room` VALUES (784, 388, 360, 4, '7-22-2');
INSERT INTO `room` VALUES (785, 389, 360, 4, '7-23-1');
INSERT INTO `room` VALUES (786, 389, 360, 4, '7-23-2');
INSERT INTO `room` VALUES (787, 390, 360, 4, '7-24-1');
INSERT INTO `room` VALUES (788, 390, 360, 4, '7-24-2');
INSERT INTO `room` VALUES (789, 391, 360, 4, '7-25-1');
INSERT INTO `room` VALUES (790, 391, 360, 4, '7-25-2');
INSERT INTO `room` VALUES (791, 392, 360, 4, '7-26-1');
INSERT INTO `room` VALUES (792, 392, 360, 4, '7-26-2');
INSERT INTO `room` VALUES (793, 393, 360, 4, '7-27-1');
INSERT INTO `room` VALUES (794, 393, 360, 4, '7-27-2');
INSERT INTO `room` VALUES (795, 394, 360, 4, '7-28-1');
INSERT INTO `room` VALUES (796, 394, 360, 4, '7-28-2');
INSERT INTO `room` VALUES (797, 395, 360, 4, '7-29-1');
INSERT INTO `room` VALUES (798, 395, 360, 4, '7-29-2');
INSERT INTO `room` VALUES (799, 396, 360, 4, '7-30-1');
INSERT INTO `room` VALUES (800, 396, 360, 4, '7-30-2');
INSERT INTO `room` VALUES (801, 397, 360, 4, '7-31-1');
INSERT INTO `room` VALUES (802, 397, 360, 4, '7-31-2');
INSERT INTO `room` VALUES (803, 398, 360, 4, '7-32-1');
INSERT INTO `room` VALUES (804, 398, 360, 4, '7-32-2');
INSERT INTO `room` VALUES (805, 399, 360, 4, '7-33-1');
INSERT INTO `room` VALUES (806, 399, 360, 4, '7-33-2');
INSERT INTO `room` VALUES (807, 400, 360, 4, '7-34-1');
INSERT INTO `room` VALUES (808, 400, 360, 4, '7-34-2');
INSERT INTO `room` VALUES (809, 401, 360, 4, '7-35-1');
INSERT INTO `room` VALUES (810, 401, 360, 4, '7-35-2');
INSERT INTO `room` VALUES (811, 402, 360, 4, '7-36-1');
INSERT INTO `room` VALUES (812, 402, 360, 4, '7-36-2');
INSERT INTO `room` VALUES (813, 403, 360, 4, '7-37-1');
INSERT INTO `room` VALUES (814, 403, 360, 4, '7-37-2');
INSERT INTO `room` VALUES (815, 404, 360, 4, '7-38-1');
INSERT INTO `room` VALUES (816, 404, 360, 4, '7-38-2');
INSERT INTO `room` VALUES (817, 405, 256, 4, '2-1-1');
INSERT INTO `room` VALUES (818, 405, 315, 4, '2-1-2');
INSERT INTO `room` VALUES (819, 405, 180, 4, '2-1-3');
INSERT INTO `room` VALUES (820, 405, 420, 4, '2-1-4');
INSERT INTO `room` VALUES (821, 406, 256, 4, '2-2-1');
INSERT INTO `room` VALUES (822, 406, 315, 4, '2-2-2');
INSERT INTO `room` VALUES (823, 406, 180, 4, '2-2-3');
INSERT INTO `room` VALUES (824, 406, 420, 4, '2-2-4');
INSERT INTO `room` VALUES (825, 407, 256, 4, '2-3-1');
INSERT INTO `room` VALUES (826, 407, 315, 4, '2-3-2');
INSERT INTO `room` VALUES (827, 407, 180, 4, '2-3-3');
INSERT INTO `room` VALUES (828, 407, 420, 4, '2-3-4');
INSERT INTO `room` VALUES (829, 408, 256, 4, '2-4-1');
INSERT INTO `room` VALUES (830, 408, 315, 4, '2-4-2');
INSERT INTO `room` VALUES (831, 408, 180, 4, '2-4-3');
INSERT INTO `room` VALUES (832, 408, 420, 4, '2-4-4');
INSERT INTO `room` VALUES (833, 409, 256, 4, '2-5-1');
INSERT INTO `room` VALUES (834, 409, 315, 4, '2-5-2');
INSERT INTO `room` VALUES (835, 409, 180, 4, '2-5-3');
INSERT INTO `room` VALUES (836, 409, 420, 4, '2-5-4');
INSERT INTO `room` VALUES (837, 410, 256, 4, '2-6-1');
INSERT INTO `room` VALUES (838, 410, 315, 4, '2-6-2');
INSERT INTO `room` VALUES (839, 410, 180, 4, '2-6-3');
INSERT INTO `room` VALUES (840, 410, 420, 4, '2-6-4');
INSERT INTO `room` VALUES (841, 411, 256, 4, '2-7-1');
INSERT INTO `room` VALUES (842, 411, 315, 4, '2-7-2');
INSERT INTO `room` VALUES (843, 411, 180, 4, '2-7-3');
INSERT INTO `room` VALUES (844, 411, 420, 4, '2-7-4');
INSERT INTO `room` VALUES (845, 412, 256, 4, '2-8-1');
INSERT INTO `room` VALUES (846, 412, 315, 4, '2-8-2');
INSERT INTO `room` VALUES (847, 412, 180, 4, '2-8-3');
INSERT INTO `room` VALUES (848, 412, 420, 4, '2-8-4');
INSERT INTO `room` VALUES (849, 413, 256, 4, '2-9-1');
INSERT INTO `room` VALUES (850, 413, 315, 4, '2-9-2');
INSERT INTO `room` VALUES (851, 413, 180, 4, '2-9-3');
INSERT INTO `room` VALUES (852, 413, 420, 4, '2-9-4');
INSERT INTO `room` VALUES (853, 414, 256, 4, '2-10-1');
INSERT INTO `room` VALUES (854, 414, 315, 4, '2-10-2');
INSERT INTO `room` VALUES (855, 414, 180, 4, '2-10-3');
INSERT INTO `room` VALUES (856, 414, 420, 4, '2-10-4');
INSERT INTO `room` VALUES (857, 415, 256, 4, '2-11-1');
INSERT INTO `room` VALUES (858, 415, 315, 4, '2-11-2');
INSERT INTO `room` VALUES (859, 415, 180, 4, '2-11-3');
INSERT INTO `room` VALUES (860, 415, 420, 4, '2-11-4');
INSERT INTO `room` VALUES (861, 416, 256, 4, '2-12-1');
INSERT INTO `room` VALUES (862, 416, 315, 4, '2-12-2');
INSERT INTO `room` VALUES (863, 416, 180, 4, '2-12-3');
INSERT INTO `room` VALUES (864, 416, 420, 4, '2-12-4');
INSERT INTO `room` VALUES (865, 417, 256, 4, '2-13-1');
INSERT INTO `room` VALUES (866, 417, 315, 4, '2-13-2');
INSERT INTO `room` VALUES (867, 417, 180, 4, '2-13-3');
INSERT INTO `room` VALUES (868, 417, 420, 4, '2-13-4');
INSERT INTO `room` VALUES (869, 418, 256, 4, '2-14-1');
INSERT INTO `room` VALUES (870, 418, 315, 4, '2-14-2');
INSERT INTO `room` VALUES (871, 418, 180, 4, '2-14-3');
INSERT INTO `room` VALUES (872, 418, 420, 4, '2-14-4');
INSERT INTO `room` VALUES (873, 419, 256, 4, '2-15-1');
INSERT INTO `room` VALUES (874, 419, 315, 4, '2-15-2');
INSERT INTO `room` VALUES (875, 419, 180, 4, '2-15-3');
INSERT INTO `room` VALUES (876, 419, 420, 4, '2-15-4');
INSERT INTO `room` VALUES (877, 420, 256, 4, '2-16-1');
INSERT INTO `room` VALUES (878, 420, 315, 4, '2-16-2');
INSERT INTO `room` VALUES (879, 420, 180, 4, '2-16-3');
INSERT INTO `room` VALUES (880, 420, 420, 4, '2-16-4');
INSERT INTO `room` VALUES (881, 421, 256, 4, '2-17-1');
INSERT INTO `room` VALUES (882, 421, 315, 4, '2-17-2');
INSERT INTO `room` VALUES (883, 421, 180, 4, '2-17-3');
INSERT INTO `room` VALUES (884, 421, 420, 4, '2-17-4');
INSERT INTO `room` VALUES (885, 422, 256, 4, '2-18-1');
INSERT INTO `room` VALUES (886, 422, 315, 4, '2-18-2');
INSERT INTO `room` VALUES (887, 422, 180, 4, '2-18-3');
INSERT INTO `room` VALUES (888, 422, 420, 4, '2-18-4');
INSERT INTO `room` VALUES (889, 423, 256, 4, '2-19-1');
INSERT INTO `room` VALUES (890, 423, 315, 4, '2-19-2');
INSERT INTO `room` VALUES (891, 423, 180, 4, '2-19-3');
INSERT INTO `room` VALUES (892, 423, 420, 4, '2-19-4');
INSERT INTO `room` VALUES (893, 424, 256, 4, '2-20-1');
INSERT INTO `room` VALUES (894, 424, 315, 4, '2-20-2');
INSERT INTO `room` VALUES (895, 424, 180, 4, '2-20-3');
INSERT INTO `room` VALUES (896, 424, 420, 4, '2-20-4');
INSERT INTO `room` VALUES (897, 425, 256, 4, '3-1-1');
INSERT INTO `room` VALUES (898, 425, 315, 4, '3-1-2');
INSERT INTO `room` VALUES (899, 425, 180, 4, '3-1-3');
INSERT INTO `room` VALUES (900, 425, 420, 4, '3-1-4');
INSERT INTO `room` VALUES (901, 426, 256, 4, '3-2-1');
INSERT INTO `room` VALUES (902, 426, 315, 4, '3-2-2');
INSERT INTO `room` VALUES (903, 426, 180, 4, '3-2-3');
INSERT INTO `room` VALUES (904, 426, 420, 4, '3-2-4');
INSERT INTO `room` VALUES (905, 427, 256, 4, '3-3-1');
INSERT INTO `room` VALUES (906, 427, 315, 4, '3-3-2');
INSERT INTO `room` VALUES (907, 427, 180, 4, '3-3-3');
INSERT INTO `room` VALUES (908, 427, 420, 4, '3-3-4');
INSERT INTO `room` VALUES (909, 428, 256, 4, '3-4-1');
INSERT INTO `room` VALUES (910, 428, 315, 4, '3-4-2');
INSERT INTO `room` VALUES (911, 428, 180, 4, '3-4-3');
INSERT INTO `room` VALUES (912, 428, 420, 4, '3-4-4');
INSERT INTO `room` VALUES (913, 429, 256, 4, '3-5-1');
INSERT INTO `room` VALUES (914, 429, 315, 4, '3-5-2');
INSERT INTO `room` VALUES (915, 429, 180, 4, '3-5-3');
INSERT INTO `room` VALUES (916, 429, 420, 4, '3-5-4');
INSERT INTO `room` VALUES (917, 430, 256, 4, '3-6-1');
INSERT INTO `room` VALUES (918, 430, 315, 4, '3-6-2');
INSERT INTO `room` VALUES (919, 430, 180, 4, '3-6-3');
INSERT INTO `room` VALUES (920, 430, 420, 4, '3-6-4');
INSERT INTO `room` VALUES (921, 431, 256, 4, '3-7-1');
INSERT INTO `room` VALUES (922, 431, 315, 4, '3-7-2');
INSERT INTO `room` VALUES (923, 431, 180, 4, '3-7-3');
INSERT INTO `room` VALUES (924, 431, 420, 4, '3-7-4');
INSERT INTO `room` VALUES (925, 432, 256, 4, '3-8-1');
INSERT INTO `room` VALUES (926, 432, 315, 4, '3-8-2');
INSERT INTO `room` VALUES (927, 432, 180, 4, '3-8-3');
INSERT INTO `room` VALUES (928, 432, 420, 4, '3-8-4');
INSERT INTO `room` VALUES (929, 433, 256, 4, '3-9-1');
INSERT INTO `room` VALUES (930, 433, 315, 4, '3-9-2');
INSERT INTO `room` VALUES (931, 433, 180, 4, '3-9-3');
INSERT INTO `room` VALUES (932, 433, 420, 4, '3-9-4');
INSERT INTO `room` VALUES (933, 434, 256, 4, '3-10-1');
INSERT INTO `room` VALUES (934, 434, 315, 4, '3-10-2');
INSERT INTO `room` VALUES (935, 434, 180, 4, '3-10-3');
INSERT INTO `room` VALUES (936, 434, 420, 4, '3-10-4');
INSERT INTO `room` VALUES (937, 435, 256, 4, '3-11-1');
INSERT INTO `room` VALUES (938, 435, 315, 4, '3-11-2');
INSERT INTO `room` VALUES (939, 435, 180, 4, '3-11-3');
INSERT INTO `room` VALUES (940, 435, 420, 4, '3-11-4');
INSERT INTO `room` VALUES (941, 436, 256, 4, '3-12-1');
INSERT INTO `room` VALUES (942, 436, 315, 4, '3-12-2');
INSERT INTO `room` VALUES (943, 436, 180, 4, '3-12-3');
INSERT INTO `room` VALUES (944, 436, 420, 4, '3-12-4');
INSERT INTO `room` VALUES (945, 437, 256, 4, '3-13-1');
INSERT INTO `room` VALUES (946, 437, 315, 4, '3-13-2');
INSERT INTO `room` VALUES (947, 437, 180, 4, '3-13-3');
INSERT INTO `room` VALUES (948, 437, 420, 4, '3-13-4');
INSERT INTO `room` VALUES (949, 438, 256, 4, '3-14-1');
INSERT INTO `room` VALUES (950, 438, 315, 4, '3-14-2');
INSERT INTO `room` VALUES (951, 438, 180, 4, '3-14-3');
INSERT INTO `room` VALUES (952, 438, 420, 4, '3-14-4');
INSERT INTO `room` VALUES (953, 439, 256, 4, '3-15-1');
INSERT INTO `room` VALUES (954, 439, 315, 4, '3-15-2');
INSERT INTO `room` VALUES (955, 439, 180, 4, '3-15-3');
INSERT INTO `room` VALUES (956, 439, 420, 4, '3-15-4');
INSERT INTO `room` VALUES (957, 440, 256, 4, '3-16-1');
INSERT INTO `room` VALUES (958, 440, 315, 4, '3-16-2');
INSERT INTO `room` VALUES (959, 440, 180, 4, '3-16-3');
INSERT INTO `room` VALUES (960, 440, 420, 4, '3-16-4');
INSERT INTO `room` VALUES (961, 441, 256, 4, '3-17-1');
INSERT INTO `room` VALUES (962, 441, 315, 4, '3-17-2');
INSERT INTO `room` VALUES (963, 441, 180, 4, '3-17-3');
INSERT INTO `room` VALUES (964, 441, 420, 4, '3-17-4');
INSERT INTO `room` VALUES (965, 442, 256, 4, '3-18-1');
INSERT INTO `room` VALUES (966, 442, 315, 4, '3-18-2');
INSERT INTO `room` VALUES (967, 442, 180, 4, '3-18-3');
INSERT INTO `room` VALUES (968, 442, 420, 4, '3-18-4');
INSERT INTO `room` VALUES (969, 443, 256, 4, '3-19-1');
INSERT INTO `room` VALUES (970, 443, 315, 4, '3-19-2');
INSERT INTO `room` VALUES (971, 443, 180, 4, '3-19-3');
INSERT INTO `room` VALUES (972, 443, 420, 4, '3-19-4');
INSERT INTO `room` VALUES (973, 444, 256, 4, '3-20-1');
INSERT INTO `room` VALUES (974, 444, 315, 4, '3-20-2');
INSERT INTO `room` VALUES (975, 444, 180, 4, '3-20-3');
INSERT INTO `room` VALUES (976, 444, 420, 4, '3-20-4');
INSERT INTO `room` VALUES (977, 445, 256, 4, '4-1-1');
INSERT INTO `room` VALUES (978, 445, 315, 4, '4-1-2');
INSERT INTO `room` VALUES (979, 445, 180, 4, '4-1-3');
INSERT INTO `room` VALUES (980, 445, 420, 4, '4-1-4');
INSERT INTO `room` VALUES (981, 446, 256, 4, '4-2-1');
INSERT INTO `room` VALUES (982, 446, 315, 4, '4-2-2');
INSERT INTO `room` VALUES (983, 446, 180, 4, '4-2-3');
INSERT INTO `room` VALUES (984, 446, 420, 4, '4-2-4');
INSERT INTO `room` VALUES (985, 447, 256, 4, '4-3-1');
INSERT INTO `room` VALUES (986, 447, 315, 4, '4-3-2');
INSERT INTO `room` VALUES (987, 447, 180, 4, '4-3-3');
INSERT INTO `room` VALUES (988, 447, 420, 4, '4-3-4');
INSERT INTO `room` VALUES (989, 448, 256, 4, '4-4-1');
INSERT INTO `room` VALUES (990, 448, 315, 4, '4-4-2');
INSERT INTO `room` VALUES (991, 448, 180, 4, '4-4-3');
INSERT INTO `room` VALUES (992, 448, 420, 4, '4-4-4');
INSERT INTO `room` VALUES (993, 449, 256, 4, '4-5-1');
INSERT INTO `room` VALUES (994, 449, 315, 4, '4-5-2');
INSERT INTO `room` VALUES (995, 449, 180, 4, '4-5-3');
INSERT INTO `room` VALUES (996, 449, 420, 4, '4-5-4');
INSERT INTO `room` VALUES (997, 450, 256, 4, '4-6-1');
INSERT INTO `room` VALUES (998, 450, 315, 4, '4-6-2');
INSERT INTO `room` VALUES (999, 450, 180, 4, '4-6-3');
INSERT INTO `room` VALUES (1000, 450, 420, 4, '4-6-4');
INSERT INTO `room` VALUES (1001, 451, 256, 4, '4-7-1');
INSERT INTO `room` VALUES (1002, 451, 315, 4, '4-7-2');
INSERT INTO `room` VALUES (1003, 451, 180, 4, '4-7-3');
INSERT INTO `room` VALUES (1004, 451, 420, 4, '4-7-4');
INSERT INTO `room` VALUES (1005, 452, 256, 4, '4-8-1');
INSERT INTO `room` VALUES (1006, 452, 315, 4, '4-8-2');
INSERT INTO `room` VALUES (1007, 452, 180, 4, '4-8-3');
INSERT INTO `room` VALUES (1008, 452, 420, 4, '4-8-4');
INSERT INTO `room` VALUES (1009, 453, 256, 4, '4-9-1');
INSERT INTO `room` VALUES (1010, 453, 315, 4, '4-9-2');
INSERT INTO `room` VALUES (1011, 453, 180, 4, '4-9-3');
INSERT INTO `room` VALUES (1012, 453, 420, 4, '4-9-4');
INSERT INTO `room` VALUES (1013, 454, 256, 4, '4-10-1');
INSERT INTO `room` VALUES (1014, 454, 315, 4, '4-10-2');
INSERT INTO `room` VALUES (1015, 454, 180, 4, '4-10-3');
INSERT INTO `room` VALUES (1016, 454, 420, 4, '4-10-4');
INSERT INTO `room` VALUES (1017, 455, 256, 4, '4-11-1');
INSERT INTO `room` VALUES (1018, 455, 315, 4, '4-11-2');
INSERT INTO `room` VALUES (1019, 455, 180, 4, '4-11-3');
INSERT INTO `room` VALUES (1020, 455, 420, 4, '4-11-4');
INSERT INTO `room` VALUES (1021, 456, 256, 4, '4-12-1');
INSERT INTO `room` VALUES (1022, 456, 315, 4, '4-12-2');
INSERT INTO `room` VALUES (1023, 456, 180, 4, '4-12-3');
INSERT INTO `room` VALUES (1024, 456, 420, 4, '4-12-4');
INSERT INTO `room` VALUES (1025, 457, 256, 4, '4-13-1');
INSERT INTO `room` VALUES (1026, 457, 315, 4, '4-13-2');
INSERT INTO `room` VALUES (1027, 457, 180, 4, '4-13-3');
INSERT INTO `room` VALUES (1028, 457, 420, 4, '4-13-4');
INSERT INTO `room` VALUES (1029, 458, 256, 4, '4-14-1');
INSERT INTO `room` VALUES (1030, 458, 315, 4, '4-14-2');
INSERT INTO `room` VALUES (1031, 458, 180, 4, '4-14-3');
INSERT INTO `room` VALUES (1032, 458, 420, 4, '4-14-4');
INSERT INTO `room` VALUES (1033, 459, 256, 4, '4-15-1');
INSERT INTO `room` VALUES (1034, 459, 315, 4, '4-15-2');
INSERT INTO `room` VALUES (1035, 459, 180, 4, '4-15-3');
INSERT INTO `room` VALUES (1036, 459, 420, 4, '4-15-4');
INSERT INTO `room` VALUES (1037, 460, 256, 4, '4-16-1');
INSERT INTO `room` VALUES (1038, 460, 315, 4, '4-16-2');
INSERT INTO `room` VALUES (1039, 460, 180, 4, '4-16-3');
INSERT INTO `room` VALUES (1040, 460, 420, 4, '4-16-4');
INSERT INTO `room` VALUES (1041, 461, 256, 4, '4-17-1');
INSERT INTO `room` VALUES (1042, 461, 315, 4, '4-17-2');
INSERT INTO `room` VALUES (1043, 461, 180, 4, '4-17-3');
INSERT INTO `room` VALUES (1044, 461, 420, 4, '4-17-4');
INSERT INTO `room` VALUES (1045, 462, 256, 4, '4-18-1');
INSERT INTO `room` VALUES (1046, 462, 315, 4, '4-18-2');
INSERT INTO `room` VALUES (1047, 462, 180, 4, '4-18-3');
INSERT INTO `room` VALUES (1048, 462, 420, 4, '4-18-4');
INSERT INTO `room` VALUES (1049, 463, 256, 4, '4-19-1');
INSERT INTO `room` VALUES (1050, 463, 315, 4, '4-19-2');
INSERT INTO `room` VALUES (1051, 463, 180, 4, '4-19-3');
INSERT INTO `room` VALUES (1052, 463, 420, 4, '4-19-4');
INSERT INTO `room` VALUES (1053, 464, 256, 4, '4-20-1');
INSERT INTO `room` VALUES (1054, 464, 315, 4, '4-20-2');
INSERT INTO `room` VALUES (1055, 464, 180, 4, '4-20-3');
INSERT INTO `room` VALUES (1056, 464, 420, 4, '4-20-4');
INSERT INTO `room` VALUES (1057, 465, 256, 4, '5-1-1');
INSERT INTO `room` VALUES (1058, 465, 315, 4, '5-1-2');
INSERT INTO `room` VALUES (1059, 465, 180, 4, '5-1-3');
INSERT INTO `room` VALUES (1060, 465, 420, 4, '5-1-4');
INSERT INTO `room` VALUES (1061, 466, 256, 4, '5-2-1');
INSERT INTO `room` VALUES (1062, 466, 315, 4, '5-2-2');
INSERT INTO `room` VALUES (1063, 466, 180, 4, '5-2-3');
INSERT INTO `room` VALUES (1064, 466, 420, 4, '5-2-4');
INSERT INTO `room` VALUES (1065, 467, 256, 4, '5-3-1');
INSERT INTO `room` VALUES (1066, 467, 315, 4, '5-3-2');
INSERT INTO `room` VALUES (1067, 467, 180, 4, '5-3-3');
INSERT INTO `room` VALUES (1068, 467, 420, 4, '5-3-4');
INSERT INTO `room` VALUES (1069, 468, 256, 4, '5-4-1');
INSERT INTO `room` VALUES (1070, 468, 315, 4, '5-4-2');
INSERT INTO `room` VALUES (1071, 468, 180, 4, '5-4-3');
INSERT INTO `room` VALUES (1072, 468, 420, 4, '5-4-4');
INSERT INTO `room` VALUES (1073, 469, 256, 4, '5-5-1');
INSERT INTO `room` VALUES (1074, 469, 315, 4, '5-5-2');
INSERT INTO `room` VALUES (1075, 469, 180, 4, '5-5-3');
INSERT INTO `room` VALUES (1076, 469, 420, 4, '5-5-4');
INSERT INTO `room` VALUES (1077, 470, 256, 4, '5-6-1');
INSERT INTO `room` VALUES (1078, 470, 315, 4, '5-6-2');
INSERT INTO `room` VALUES (1079, 470, 180, 4, '5-6-3');
INSERT INTO `room` VALUES (1080, 470, 420, 4, '5-6-4');
INSERT INTO `room` VALUES (1081, 471, 256, 4, '5-7-1');
INSERT INTO `room` VALUES (1082, 471, 315, 4, '5-7-2');
INSERT INTO `room` VALUES (1083, 471, 180, 4, '5-7-3');
INSERT INTO `room` VALUES (1084, 471, 420, 4, '5-7-4');
INSERT INTO `room` VALUES (1085, 472, 256, 4, '5-8-1');
INSERT INTO `room` VALUES (1086, 472, 315, 4, '5-8-2');
INSERT INTO `room` VALUES (1087, 472, 180, 4, '5-8-3');
INSERT INTO `room` VALUES (1088, 472, 420, 4, '5-8-4');
INSERT INTO `room` VALUES (1089, 473, 256, 4, '5-9-1');
INSERT INTO `room` VALUES (1090, 473, 315, 4, '5-9-2');
INSERT INTO `room` VALUES (1091, 473, 180, 4, '5-9-3');
INSERT INTO `room` VALUES (1092, 473, 420, 4, '5-9-4');
INSERT INTO `room` VALUES (1093, 474, 256, 4, '5-10-1');
INSERT INTO `room` VALUES (1094, 474, 315, 4, '5-10-2');
INSERT INTO `room` VALUES (1095, 474, 180, 4, '5-10-3');
INSERT INTO `room` VALUES (1096, 474, 420, 4, '5-10-4');
INSERT INTO `room` VALUES (1097, 475, 256, 4, '5-11-1');
INSERT INTO `room` VALUES (1098, 475, 315, 4, '5-11-2');
INSERT INTO `room` VALUES (1099, 475, 180, 4, '5-11-3');
INSERT INTO `room` VALUES (1100, 475, 420, 4, '5-11-4');
INSERT INTO `room` VALUES (1101, 476, 256, 4, '5-12-1');
INSERT INTO `room` VALUES (1102, 476, 315, 4, '5-12-2');
INSERT INTO `room` VALUES (1103, 476, 180, 4, '5-12-3');
INSERT INTO `room` VALUES (1104, 476, 420, 4, '5-12-4');
INSERT INTO `room` VALUES (1105, 477, 256, 4, '5-13-1');
INSERT INTO `room` VALUES (1106, 477, 315, 4, '5-13-2');
INSERT INTO `room` VALUES (1107, 477, 180, 4, '5-13-3');
INSERT INTO `room` VALUES (1108, 477, 420, 4, '5-13-4');
INSERT INTO `room` VALUES (1109, 478, 256, 4, '5-14-1');
INSERT INTO `room` VALUES (1110, 478, 315, 4, '5-14-2');
INSERT INTO `room` VALUES (1111, 478, 180, 4, '5-14-3');
INSERT INTO `room` VALUES (1112, 478, 420, 4, '5-14-4');
INSERT INTO `room` VALUES (1113, 479, 256, 4, '5-15-1');
INSERT INTO `room` VALUES (1114, 479, 315, 4, '5-15-2');
INSERT INTO `room` VALUES (1115, 479, 180, 4, '5-15-3');
INSERT INTO `room` VALUES (1116, 479, 420, 4, '5-15-4');
INSERT INTO `room` VALUES (1117, 480, 256, 4, '5-16-1');
INSERT INTO `room` VALUES (1118, 480, 315, 4, '5-16-2');
INSERT INTO `room` VALUES (1119, 480, 180, 4, '5-16-3');
INSERT INTO `room` VALUES (1120, 480, 420, 4, '5-16-4');
INSERT INTO `room` VALUES (1121, 481, 256, 4, '5-17-1');
INSERT INTO `room` VALUES (1122, 481, 315, 4, '5-17-2');
INSERT INTO `room` VALUES (1123, 481, 180, 4, '5-17-3');
INSERT INTO `room` VALUES (1124, 481, 420, 4, '5-17-4');
INSERT INTO `room` VALUES (1125, 482, 256, 4, '5-18-1');
INSERT INTO `room` VALUES (1126, 482, 315, 4, '5-18-2');
INSERT INTO `room` VALUES (1127, 482, 180, 4, '5-18-3');
INSERT INTO `room` VALUES (1128, 482, 420, 4, '5-18-4');
INSERT INTO `room` VALUES (1129, 483, 256, 4, '5-19-1');
INSERT INTO `room` VALUES (1130, 483, 315, 4, '5-19-2');
INSERT INTO `room` VALUES (1131, 483, 180, 4, '5-19-3');
INSERT INTO `room` VALUES (1132, 483, 420, 4, '5-19-4');
INSERT INTO `room` VALUES (1133, 484, 256, 4, '5-20-1');
INSERT INTO `room` VALUES (1134, 484, 315, 4, '5-20-2');
INSERT INTO `room` VALUES (1135, 484, 180, 2, '5-20-3');
INSERT INTO `room` VALUES (1136, 484, 420, 2, '5-20-4');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `userid` int NOT NULL AUTO_INCREMENT,
  `account` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `idcard` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `gender` smallint NOT NULL COMMENT '男-1、女-0',
  `age` smallint NOT NULL,
  `user_type` smallint NOT NULL COMMENT '用户类型：1、管理员；2、物业；3、业主；',
  `user_status` smallint NOT NULL COMMENT '11、管理员使用；21、物业人员使用；31、常住业主；32、租户；33、未激活',
  `user_roomid` int NULL DEFAULT NULL,
  `user_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'https://rpsm.oss-cn-chengdu.aliyuncs.com/default.jpg' COMMENT '头像路径',
  PRIMARY KEY (`userid`) USING BTREE,
  UNIQUE INDEX `account`(`account`) USING BTREE,
  UNIQUE INDEX `idcard`(`idcard`) USING BTREE,
  INDEX `user_roomid`(`user_roomid`) USING BTREE,
  CONSTRAINT `user_ibfk_1` FOREIGN KEY (`user_roomid`) REFERENCES `room` (`room_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (3, '18784877777', 'e10adc3949ba59abbe56e057f20f883e', '511823200404101361', '魏进', 1, 19, 3, 31, 25, 'https://rpsm.oss-cn-chengdu.aliyuncs.com/weijin.jpg');
INSERT INTO `user` VALUES (4, '18784876666', 'e10adc3949ba59abbe56e057f20f883e', '486513206541320', '熊小伟', 1, 19, 3, 31, 26, 'https://rpsm.oss-cn-chengdu.aliyuncs.com/2ea3ac13-0102-4c5e-9662-6b0c5f6378c8.jpg');
INSERT INTO `user` VALUES (5, '18784878888', 'e10adc3949ba59abbe56e057f20f883e', '465132563123123', '雷诚新', 1, 19, 3, 31, 27, 'https://rpsm.oss-cn-chengdu.aliyuncs.com/11285d1f-052b-4ba9-a515-88d639a8642a.jpg');
INSERT INTO `user` VALUES (6, '18788888888', 'e10adc3949ba59abbe56e057f20f883e', '1354156465465', '张三', 0, 50, 3, 31, 81, 'https://rpsm.oss-cn-chengdu.aliyuncs.com/860607e7-ad97-487b-afd9-7b54da824875.jpg');
INSERT INTO `user` VALUES (7, 'c3ad1247522', 'e10adc3949ba59abbe56e057f20f883e', '4165415616352', '李四', 1, 50, 3, 33, 144, 'https://rpsm.oss-cn-chengdu.aliyuncs.com/1cfc3d67-2660-482a-b4ab-ed8e082baeae.jpg');
INSERT INTO `user` VALUES (8, 'a1255548992', 'e10adc3949ba59abbe56e057f20f883e', '16535132121651', '王五', 0, 36, 3, 33, 139, 'https://rpsm.oss-cn-chengdu.aliyuncs.com/1cfc3d67-2660-482a-b4ab-ed8e082baeae.jpg');
INSERT INTO `user` VALUES (10, 'ab0ccc54113', 'e10adc3949ba59abbe56e057f20f883e', '23313215643132', '赵六', 0, 36, 3, 33, 140, 'https://rpsm.oss-cn-chengdu.aliyuncs.com/1cfc3d67-2660-482a-b4ab-ed8e082baeae.jpg');
INSERT INTO `user` VALUES (11, '14df8dc9571', 'e10adc3949ba59abbe56e057f20f883e', '6535646131222', '钱七', 1, 36, 3, 33, 203, 'https://rpsm.oss-cn-chengdu.aliyuncs.com/1cfc3d67-2660-482a-b4ab-ed8e082baeae.jpg');
INSERT INTO `user` VALUES (12, 'dsgsf655645', 'e10adc3949ba59abbe56e057f20f883e', '46546132165', '林一', 1, 45, 3, 33, 204, 'https://rpsm.oss-cn-chengdu.aliyuncs.com/1cfc3d67-2660-482a-b4ab-ed8e082baeae.jpg');
INSERT INTO `user` VALUES (13, '19119088570', 'd41d8cd98f00b204e9800998ecf8427e', '464132135433', '林二', 0, 45, 3, 31, 115, 'https://rpsm.oss-cn-chengdu.aliyuncs.com/fc3f02e6-bd03-4741-9bf1-342756fc701b.jpg');
INSERT INTO `user` VALUES (14, '91f5ca96731', 'e10adc3949ba59abbe56e057f20f883e', '1534513156132', '米彩', 0, 26, 3, 33, 33, 'https://rpsm.oss-cn-chengdu.aliyuncs.com/1cfc3d67-2660-482a-b4ab-ed8e082baeae.jpg');

SET FOREIGN_KEY_CHECKS = 1;
